Click on the first cell with a formula in it. A small black square
should be at the bottom right corner of the outline of the cell. Click
and drag this cell down; it should copy the formula the way you want.

Szalapski


--
TommySzalapski
------------------------------------------------------------------------
TommySzalapski's Profile: http://www.excelforum.com/member.php...o&userid=25561
View this thread: http://www.excelforum.com/showthread...hreadid=399915