Workbook_SheetChange
 

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

Workbook_SheetChange
 

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


"masterphilch" wrote in message

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

Workbook_SheetChange
 

thanks for that hint!

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

thanks for reply

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


"masterphilch" wrote in message

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

Workbook_SheetChange
 

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?

Workbook_SheetChange
 

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


"masterphilch" wrote in message

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



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


"masterphilch" wrote in message

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

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?