This will give you the last *numeric* entry in Column A:

=LOOKUP(9.99999999999999E+307,A:A)
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"Bg" wrote in message
...
I built a basic spreadsheet (Excel 2002) the is used for check book
balancing. There will be over 100+ rows and I would like the current
balance
to always show above the "freeze" line(row 5) in cell J4. Is there a
formula
to display this?

TIA
Bg