VBA for Selecting Last Row in Range
"David Godinger" wrote in message
I'd like to name a range and go to the last row with data in that range.
one way -
Dim rng As Range, rngBR As Range
Set rng = ActiveSheet.Range("B2:Z100")
With rng
Set rngBR = .Cells(.Rows.Count, .Columns.Count)
End With
'Debug.Print rngBR.Address
Application.Goto rngBR
Peter T
|