Workbook_SheetChange

[masterphilch]

Hi

Is it somehow possible to check if a row's been inserted? Is there any
construct of code or do I need to loop through a field and check that
'manually'?

thanks for help

masterphilch

 

[Jim Cone]

M,
Name the range and check the Rows.Count.
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware


Hi
Is it somehow possible to check if a row's been inserted? Is there any
construct of code or do I need to loop through a field and check that
'manually'?
thanks for help
masterphilch

 

[masterphilch]

thanks for that hint!

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

thanks for reply

 

[JE McGimpsey]

One way:

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

 

[Jim Cone]

m,

With Range("PhilchArea")
MsgBox .Rows(1).Row & " is the first row. "
MsgBox .Rows(.Rows.Count).Row & " is the last row. "
End With

Jim Cone
San Francisco, USA


thanks for that hint!
could it be possible to determine the start- and endrow of that named range?
thanks for reply

 

[masterphilch]

thanks a lot!

One way:

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