One way:

Dim nStartRow As Long
Dim nEndRow As Long
With Range("MyRange")
nStartRow = .Item(1).Row
nEndRow = .Item(.Count).Row
End With


In article ,
masterphilch wrote:

could it be possible to determine the start- and endrow of that named range?