Referencing last populated cell in a column
 

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!

Referencing last populated cell in a column
 

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!

Referencing last populated cell in a column
 

On Apr 27, 7:42 pm, "T. Valko" wrote:
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