Copy and Paste

[T De Villiers]

Hi,
lastcol + 4 = 7

I am trying to copy range("G1,G1000") in Sheet - Test to
Sheet BWBIF Range("a1")

I have used 'last col' variable instead of Range("G1:G1000") because
the column positioning changes.
The below doesnt quite work.

Sheets("Test").Range(Cells(1, lastcol + 4), Cells(1000, lastcol +
4)).Copy Destination:=Sheets("BWBIF").Range("A1")


Thanks

 

[Guest]

With Sheets("Test")
.Range(.Cells(1, lastcol + 4), .Cells(1000, lastcol + _
4)).Copy Destination:=Sheets("BWBIF").Range("A1")
End With

does the last column plus 4 actually contain data?

 

[T De Villiers]

Thanks Tom - works a treat