Hey Ron.

Im not sure if i follow exactly what your saying. The
Range("A1:A100") " It varys each time i copy data to the blank sheet.
What is the code that you provided supposed to do. I ran it, and i
seems to do nothing

--
jim hense
-----------------------------------------------------------------------
jim hensen's Profile: http://www.excelforum.com/member.php...fo&userid=1515
View this thread: http://www.excelforum.com/showthread.php?threadid=26889