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