View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Peter T[_8_] Peter T[_8_] is offline
external usenet poster
 
Posts: 88
Default 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