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