See this:

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

Biff

"flint" wrote in message
oups.com...
I have a worksheet with a date column alongside a column with
irregular entries. Some dates have no data alongside.

How do I reference the last cell with data in it?

I hope I have made myself clear!