Hi Angelo

Check out my answer to you in microsoft.public.excel.misc -

just for future reference it is not necessary to post to more than one group
as most of the responders here read a number of groups ... all it does is
fragment your answers and possibly upset someone who spends a considerable
amount of time coming up with a solution to a question only to discover that
it has already been answered in another group.

Cheers
JulieD
Perth, Western Australia

"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 !