Hi,

That's good thanks, but it works only if you manually alter the formula
to show where the last cell is, ie., A9.

I was hoping that the formula would recalculate automatically, so that
it somehow knows where the last entry is in the column, and works it
out from there.

Sorry for being a picky so and so!!

Thanks,
Dan.


--
Voodoodan
------------------------------------------------------------------------
Voodoodan's Profile: http://www.excelforum.com/member.php...nfo&userid=597
View this thread: http://www.excelforum.com/showthread...hreadid=525630