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?

--
Regards,
Tom Ogilvy


"T De Villiers" wrote:


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


--
T De Villiers
------------------------------------------------------------------------
T De Villiers's Profile: http://www.excelforum.com/member.php...o&userid=26479
View this thread: http://www.excelforum.com/showthread...hreadid=566731