CODEWITHSUNDEEP
vbaexcel
Paul Demay
Paul Demay

Reputation: 21

Excel Macro Macro / VBA Error 1004 - Copy Paste With Variable

Why does this work:

Sheets("Sheet1-Orig").Range(Sheets("Sheet1-Orig").Cells(20, 1), Sheets("Sheet1-Orig").Cells(LastRow1, 3)).Copy Destination:=Sheets("3-Orig_Merged").Range("A1")

But this throws up a 1004:

Sheets("Sheet2-Orig").Range(Sheets("Sheet1-Orig").Cells(2, 1), Sheets("Sheet1-Orig").Cells(LastRow2, 3)).Copy Sheets("3-Orig_Merged").Cells(LastRow1 - 18, 1)

Getting Application defined or object defined error. Driving. Me. Nuts...

Thanks!

Upvotes: 0

Views: 63

Answers (1)

Shai Rado
Shai Rado

Reputation: 33672

Even though there are more code lines below, I find it easier to use (and debug later):

With Sheets("Sheet1-Orig")
    .Range(.Cells(20, 1), .Cells(LastRow1, 3)).Copy
End With
Sheets("3-Orig_Merged").Range("A1").PasteSpecial

Upvotes: 1

Related Questions