As an addendum, if you then want to enter a formula in B2 and copy it
down the same range, you only need to move your cursor over the lower
right corner of the cell until it turns to a 'plus' sign and double
click. This will copy the formula down as far as there is data in
Column A.

HTH

Bruce


--
swatsp0p


------------------------------------------------------------------------
swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101
View this thread: http://www.excelforum.com/showthread...hreadid=382920