HI all,

This is what I am trying to do, look in range Column A in active sheet,
copy upto whatever range is filled down and paste in sheet 2. the code
below is copying only the last cell and pasting in sheet 2.


Range("A65536").End(xlUp).Copy _
Worksheets("sheet2").Range("a65536").End(xlUp)

Appreciate your help.
Thanks
Syed


--
saziz
------------------------------------------------------------------------
saziz's Profile: http://www.excelforum.com/member.php...fo&userid=6350
View this thread: http://www.excelforum.com/showthread...hreadid=471513