After Insert

[Steven]

Is there a way to tell when a line insert occured. I do not see an
AfterInsert routine.

Thank you,

Steven.

 

[Barb Reinhardt]

You could probably find it with a worksheet_change event and look for

Target.Columns.Count = ME.Columns.Count

 

[Matthew Norman]

I used the following within the Worksheet_Change event

If Target.Address = Target.EntireRow.Address then

'Row has been inserted or deleted


End if

 

[Steven]

Those are nice. Thank you. What I want to do is specifically catch the
insert. Is there a way do that?

Thanks again.