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?
 
Back
Top