Paul,

This won't select it, only a macro could do that, but this formula will
display the last cell. There can be no empty cells along the way.

=OFFSET(A1,COUNTA(A:A)-1,0,1,1)

--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

"Paul - South Australia" <Paul - South
wrote in message ...
With a column of data I want to automatically select the last line and
display it in another cell, possible?