one other thing, if you try to copy this code & run it you need a spread
sheet open with a couple of celles with the value 1 or 2 in them
starting in the A1 cell and working down, it stops at the 1st empy
cell.

eric


--
cjsasl
------------------------------------------------------------------------
cjsasl's Profile: http://www.excelforum.com/member.php...o&userid=28712
View this thread: http://www.excelforum.com/showthread...hreadid=484006