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

Thank you,

Steven.

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.

I used the following within the Worksheet_Change event

If Target.Address = Target.EntireRow.Address then

'Row has been inserted or deleted


End if

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
>