VBA for Selecting Last Row in Range
"David Godinger" wrote in message
Yes, getting the last cell of text or numbers in one column is easy, but
that's not what I'm asking for.
OK try this -
Sub test()
Dim rngData As Range
Dim rngFound As Range
Set rngData = Range("B2:J20")
Set rngFound = rngData.Find("*", rngData.Cells(1), xlValues, , xlByRows,
xlPrevious)
If rngFound Is Nothing Then
MsgBox rngData.address & " is empty"
Else
MsgBox rngFound.Address
End If
End Sub
Peter T
|