Copying a column from another sheet to another - Error

[Korrikong]

Is there something wrong with my code? Please help!

"Sheets("Web Query").Columns(10).Copy Destination:=Sheets("Tracker").Range("A1")" - This is a working code but I want the copied data start at Range("A5") or Columns.(1, 5)

"Sheets("Web Query").Columns(10).Copy Destination:=Sheets("Tracker").Range("A5")" - Run-time error '1004': Application-defined or object-defined error

 

[Michael M]

If you think about it, you can't copy an entire column....then paste it 5 rows down from the start....a column IS an entire column !!
You will have to change columns to a range of cells, if you want to copy it to "A5")

 

[Korrikong]

If you think about it, you can't copy an entire column....then paste it 5 rows down from the start....a column IS an entire column !!
You will have to change columns to a range of cells, if you want to copy it to "A5")

Thanks, man!