To copy an entire column try something like, you can reference it by column
letter if you fully reference it with the name of the sheet

The following copies the entire column D on sheet1 to column A on sheet2

Sheets("Sheet1").Columns("D:D").Copy
Destination:=Sheets("Sheet2").Range("A1")

--

Regards,
Nigel




"Lucky Lucy" wrote in message
...
Hi,
How do I copy a column that is called "Product Line" into Column A? The
Product Line column is in a different column on different reports so I
cannot
reference it by column letter and hope to reference it by column
heading/name.

Thank you!
Luce