Workbook_SheetChange

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

masterphilch - 14 Jan 2006 10:12 GMT

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

Reply to this Message

Jim Cone - 14 Jan 2006 14:50 GMT

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

Reply to this Message

masterphilch - 15 Jan 2006 18:39 GMT

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.
[quoted text clipped - 8 lines]
> thanks for help
> masterphilch

Reply to this Message

JE McGimpsey - 15 Jan 2006 19:02 GMT

One way:

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

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

Reply to this Message

masterphilch - 19 Jan 2006 20:35 GMT

thanks a lot!

JE McGimpsey schrieb:

> One way:
>
[quoted text clipped - 6 lines]
>
>> could it be possible to determine the start- and endrow of that named range?

Reply to this Message

Jim Cone - 15 Jan 2006 19:09 GMT

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

Jim Cone schrieb:

> M,
> Name the range and check the Rows.Count.
[quoted text clipped - 10 lines]
> thanks for help
> masterphilch

Reply to this Message