Detecting when Excel user inserts or deletes a row

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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.
 
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
 
Back
Top