Go to the bottom-right corner of the fomula cell, click and drag it down
over the next 100 rows.


--
Leibtek
------------------------------------------------------------------------
Leibtek's Profile: http://www.excelforum.com/member.php...o&userid=32287
View this thread: http://www.excelforum.com/showthread...hreadid=520425