Workbook_SheetChange
thanks a lot!
JE McGimpsey schrieb:
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?
|