Detecting when Excel user inserts or deletes a row

[Guest]

I want to know when an Excel user either deletes or inserts a row so that I
can modify other cells to reflect the loss (or gain) of the row. Is there an
event that occurs (like in Worksheet_Change) that I can inspect to see what
they have done?

Thanks in advance.

Warren

 

[Norman Jones]

Hi W,

This is an often asked question, but no such event is exposed.

 

[Guest]

Create a range name eg rLastRow - in the last row on the test. Test the row
value of the rLastRow on a selection change event. If it differs from
previous value that you saved then your procedure can run.

 

[Guest]

Another way is to place a formula somewhere in the worksheet that refers to a
whole column like =COUNT(A:A).
Now, whenever a row is inserted or deleted, the Worksheet_Calculate event
will fire.

Regards,
Vic Eldridge