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