After Insert
 

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

Thank you,

Steven.

After Insert
 

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

Target.Columns.Count = ME.Columns.Count

--
HTH,
Barb Reinhardt




"Steven" wrote:

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

Thank you,

Steven.

After Insert
 

I used the following within the Worksheet_Change event

If Target.Address = Target.EntireRow.Address then

'Row has been inserted or deleted


End if

After Insert
 

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

Thanks again.

"Matthew Norman" wrote:

I used the following within the Worksheet_Change event

If Target.Address = Target.EntireRow.Address then

'Row has been inserted or deleted


End if