Simple Paste Issue

  • Thread starter Thread starter Shai Shefer
  • Start date Start date
S

Shai Shefer

Hi, I have a fairly quick question about pasting a captured range.

If I have (sheet names and ranges different):

Dim MyInfo As Range
Set MyInfo = Worksheets("Sheet1").Range("B1:B:2")

How can I then take MyInfo and paste it? I have tried:

Range("D1:D2").Value = MyInfo

But that doesnt seem to work. Any idea?
 
If both ranges are the same size then you can use
for only the values

Dim MyInfo As Range
Set MyInfo = Worksheets("Sheet1").Range("B1:B2")
Range("D1:D2").Value = MyInfo.Value

If you want to copy use this

MyInfo.Copy Range("D1")
 
Ron, thanks for the response...

While this does work, only the value from the first cell seems to be
copied over, the other cells in the row are not at all present. Any
ideas?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Insert columns and values programmatically with IF statement 9
Value from one sheet paste under same value on other sheet. 7
Copy columns and paste with blank column between 5
Cell values to an array, then array transpose to another workbook 8
A simple if <> nn then Msgbox "No Match" 5
Average Ifs in Excel 2010 15
Object variable or with Block variable not set 9
Transfer array element offset value to a matched value 3

Back
Top