For a worksheet formula, you could do something like this...

="D"&MATCH(LOOKUP(2,1/(A1:A65535<""),A:A),A:A,0)

For a macro solution (which, if you are in a macro, is the best way to get
this)...

LastCellInD = Cells(Rows.Count, "D").End(xlUp).Address(0,0)

--
Rick (MVP - Excel)


"mike in texas" wrote in message
...
Is it possible to return the address of the last non empty cell in a
column.
I've found lots of ways to return the value of the last cell, but I need
the
address e.g. D234.

Thanks

Mike