Take a look at http://www.xldynamic.com/source/xld.LastValue.html

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Angelo Sartore" wrote in message
...
Hello all,
I have created a worksheet where I am continually adding to a variety of
columns.
Is there a function I can use to refer a cell to lookup the last cell in a
column with an entry?

Thanks in advance,

Angelo Sartore

Melbourne
AUSTRALIA

ADOPT, ADAPT, INVENT, DESTROY !