Instead of using Range("A1") in your code, use ActiveSheet.UsedRange.
This property represents the currently selected range in your
worksheet.


--
C01d
------------------------------------------------------------------------
C01d's Profile: http://www.excelforum.com/member.php...o&userid=34422
View this thread: http://www.excelforum.com/showthread...hreadid=546352