insert row method (?)
 

is there a way to initiate code if a row has been inserted into the
worksheet, and to tell where the row(s) were inserted?

ex: if the user just inserted a new row... do this... (msgbox (you just
inserted row(s)...)

thanks in advance,

-mark

insert row method (?)
 

right click on the sheet tab and select view code

paste in this code:

Private Sub Worksheet_Change(ByVal Target As Range)
MsgBox Target.Address
End Sub

Now go back to the sheet and
Insert a row
Delete a row
select a row and hit the delete key to clear the values.

change will tell you that something has happened, but it isn't going to tell
you specifically that it is an insert or a delete - you would to code in more
knowledge of your sheet to discern whether a row insertion or deletion
triggered the change event.

--
Regards,
Tom Ogilvy


"mark kubicki" wrote:

is there a way to initiate code if a row has been inserted into the
worksheet, and to tell where the row(s) were inserted?

ex: if the user just inserted a new row... do this... (msgbox (you just
inserted row(s)...)

thanks in advance,

-mark

insert row method (?)
 

and just to Add, in xl97, if I am remembering correctly, the change event is
triggered on a insertion.

--
Regards,
Tom Ogilvy


"mark kubicki" wrote:

is there a way to initiate code if a row has been inserted into the
worksheet, and to tell where the row(s) were inserted?

ex: if the user just inserted a new row... do this... (msgbox (you just
inserted row(s)...)

thanks in advance,

-mark

insert row method (?)
 

this is good (thanks)

i'm familiar enough withthe change event... any suggestins about what the
could be coded in to discern the insert/delete and the row(s) it occurred
in?

would it make sense to create an array of cell values and addresses, and
then comapre it to the same array generated prior to the change; note the
differences and ...

-mark


"Tom Ogilvy" wrote in message
...
right click on the sheet tab and select view code

paste in this code:

Private Sub Worksheet_Change(ByVal Target As Range)
MsgBox Target.Address
End Sub

Now go back to the sheet and
Insert a row
Delete a row
select a row and hit the delete key to clear the values.

change will tell you that something has happened, but it isn't going to
tell
you specifically that it is an insert or a delete - you would to code in
more
knowledge of your sheet to discern whether a row insertion or deletion
triggered the change event.

--
Regards,
Tom Ogilvy


"mark kubicki" wrote:

is there a way to initiate code if a row has been inserted into the
worksheet, and to tell where the row(s) were inserted?

ex: if the user just inserted a new row... do this... (msgbox (you just
inserted row(s)...)

thanks in advance,

-mark

insert row method (?)
 

There is no Universal Truth here. Whatever makes sense to you makes sense.
You know what your worksheets look like and what your users may or may not
do.

but yes, the basic approach is probably one of before and after comparisons.

Maybe add in a little bit of size to the sheet and put a distinct value
below and to the right of actual used range, then check its row and column
location each time against what it used to be. Set the scrollarea and use
the selectionchange event to further prevent selection in this area.

--
Regards,
Tom Ogilvy


--
Regards,
Tom Ogilvy


"mark kubicki" wrote:

this is good (thanks)

i'm familiar enough withthe change event... any suggestins about what the
could be coded in to discern the insert/delete and the row(s) it occurred
in?

would it make sense to create an array of cell values and addresses, and
then comapre it to the same array generated prior to the change; note the
differences and ...

-mark


"Tom Ogilvy" wrote in message
...
right click on the sheet tab and select view code

paste in this code:

Private Sub Worksheet_Change(ByVal Target As Range)
MsgBox Target.Address
End Sub

Now go back to the sheet and
Insert a row
Delete a row
select a row and hit the delete key to clear the values.

change will tell you that something has happened, but it isn't going to
tell
you specifically that it is an insert or a delete - you would to code in
more
knowledge of your sheet to discern whether a row insertion or deletion
triggered the change event.

--
Regards,
Tom Ogilvy


"mark kubicki" wrote:

is there a way to initiate code if a row has been inserted into the
worksheet, and to tell where the row(s) were inserted?

ex: if the user just inserted a new row... do this... (msgbox (you just
inserted row(s)...)

thanks in advance,

-mark