Hi TG

You are trying to put a whole column into one cell. Also if you want
to copy all of Column A you need to use Range("A:A"). You could paste
this column into G1 as it will place the whole column in G but not to
G10.

Better to choose a used range in Column A, then paste it into Column
G10. Here is an example. Copies the used range in Col A to G10 in
sheet 5.

Take care

Marcus


Sub Copyit()
Dim Lw As Integer
Lw = Range("A" & Rows.Count).End(xlUp).Row
Range("A1:A" & Lw).Copy Worksheets("five").Range("G10")
End Sub