Copy data from one worksheet to another. "Run-time error' 1004"

[A Rossi]

Hi

I am trying to copy data from three columns and paste to another sheet in same workbook. Keep getting a "Run-time error' 1004"

Not sure why this is happening. Note: i am pasting into a table.

Thanks

Rick

Sub AmazonData()

With ActiveWorkbook
 Sheets("Amazon").Range("D2", Range("D" & Rows.Count).End(xlUp)).Copy Destination:=Sheets("SOURCE").Range("C" & Rows.Count).End(xlUp).Offset(1)
 Sheets("Amazon").Range("G2", Range("G" & Rows.Count).End(xlUp)).Copy Destination:=Sheets("SOURCE").Range("B" & Rows.Count).End(xlUp).Offset(1)
 Sheets("Amazon").Range("L2", Range("L" & Rows.Count).End(xlUp)).Copy Destination:=Sheets("SOURCE").Range("D" & Rows.Count).End(xlUp).Offset(1)
End With


End Sub

 

[JoeMo]

You may need to qualify your range references like this:

Sheets("Amazon").Range("D2", Sheets("Amazon").Range("D" & Rows.Count).End(xlUp)).Copy

 

[A Rossi]

Did not work. Thanks anyway.