catch event insert a row or delete a row
 

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

catch event insert a row or delete a row
 

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


"Nader" wrote in message
...
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

catch event insert a row or delete a row
 

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

"Nader" wrote in message
...
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