catch event insert a row or delete a row

[Nader]

Hello,

I would like to catch the event when I add a row into a sheet or delete a
row. So I could add or delete a row into another sheet at the same time. Is
there an event on the row ? Is there another way to do that ?

Thanks in advance

Nader

 

[Chip Pearson]

Unfortunately there is no event for when a user inserts/deletes a
row.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

 

[NickHK]

There was a recent post in this NG concerning this; can't find it now, but
Google Groups should help you.
As Chip points out, no events will tell you when this happens, so you have
to rely on something suitable; _Change or _SelectionChange.
Create a single celled named way below any data/activity. Store its row in a
variable.
In a suitable event, check its row and see if it has changed; you tell how
many up/down so how many rows inserted/deleted.

NickHK