After Insert

S

Steven

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

Thank you,

Steven.
 
B

Barb Reinhardt

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

Target.Columns.Count = ME.Columns.Count
 
M

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
 
S

Steven

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

Thanks again.
 
Top