Error copying range using Excel VBA

Question

I'm having trouble copying a range when using a variable to refer to the range being copied. The error i get is:

Run-time error '1004': Application-defined or object-defined error

Sub temp()
Dim Data As Range
Set Data = Range("A1:C1")
Range(Data).Copy Range("E1")
End Sub

There is no problem if i use

Range("A1:C1").Copy Range("E1")

I also tried

Range(Data).Copy Destination:=Range("E1")

I'm using Excel 2010. The above sample is part of a larger body of code. I've isolated the part which generates the error.

Thanks!

matzone · Accepted Answer · 2013-06-29 09:39:11Z

1

Since Data = Range("A1:C1")

Data.Copy Range("E1")

should work ..

answered Jun 29, 2013 at 9:39

matzone

5,7293 gold badges19 silver badges20 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1