See this:

http://xldynamic.com/source/xld.LastValue.html

Biff

"Bumblebee" wrote in message
...
Is there an excel funtion that retreives the last cell of a list that
contains data. And then one that will find the next to the last, etc. The
list, or series kees getting longer but I always want to link a cell in a
table to the last data of the list, at the end of the list. With the
offset
function it can be done but I was wondering if there was a better
function.

version: excel 2003