Hi,

Just to add you can use the fill handle to drag the formula down lots of rows

http://www.mvps.org/dmcritchie/excel/fillhand.htm

VBA Noob