or

Cells(Rows.Count,"B").End(xlUp).Value

--

John Green - Excel MVP
Sydney
Australia


"Bob Phillips" wrote in message ...
... or if you want VBA

Again in column B

Cells(Cells(Rows.Count,"B").End(xlUp).Row,"B").Val ue

--

HTH

Bob Phillips

"josh" wrote in message
...
the bottom of my worksheet is a database, i can't figure
out how to pull the last cell's value and make it a
variable, but since its a database i will never know
which cell is going to be the last one.

if it makes it any easier, what i'm trying to do is keep
a running balance in a worksheet, and when the worksheet
is opened, i need to pull the running balance from the
last database entry.....
and put it in another cell (i can do this part)

thanks in advance guys,
Josh Ashcraft