See this:
http://xldynamic.com/source/xld.LastValue.html
Biff
>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!
flint - 28 Apr 2007 09:21 GMT
> See this:
>
> http://xldynamic.com/source/xld.LastValue.html
>
> Biff
Thanks,
Looks like a bit of reading but I'll give it a go!
F