Thanks for the suggestion.

I'll use a macro if I have to, but what I was hoping to find is a function,
or a series of functions. For example, LAST_NONEMPTY_CELL_VAL(A:A) = 12345,
or LAST_NONEMPTY_CELL_ADDR(A:A) = "A124". Something like that.


"Gary''s Student" wrote:

Select the range and:

Sub findit()
For Each r In Selection
If IsEmpty(r) Then
Else
s = r.Address
End If
Next
MsgBox (s)
End Sub



--
Gary''s Student - gsnu200753


"Eric" wrote:

How can I find the last (meaning bottom, or right-most) non-empty cell in a
range?

Thanks.