Tory, have a look here, http://www.xldynamic.com/source/xld.LastValue.html

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"Tory" wrote in message
...
I need to display the last entry of a column series from a worksheet in a
different cell, even if additional entries are inserted into that column
series.

For example, if series is A1:A10, then A10 needs to appear. If I insert
two
rows between rows 1 and 10, the series will automatically expand to
A1:A12,
and now I need A12 to appear.

Does anyone have a solution for this? I thought about creating a custom
function, but I only know how to do very basic functions, and this is over
my
head.

Thanks for your help