Event to signal row or columns being added or dde (2000 – 2007)

Topic

New Reply

Is there a way to catch when a row or column is being added or deleted on a sheet? The Worksheet_Change event does get fired but I am not sure what property to look at to know that a row or column is being added or deleted.

Reply | Quote

Replies

As far as I know, inserting a row or column does not trigger any trappable events.

If you had a calculation in a cell in the rightmost column and bottommost row that used the row() and column() functions, inserting/deleting columns would trigger a calculation and this could be trapped, but you would have to be specific in the code of what is being done and someone have the code “discover” what triggered the calculation…

Steve

Reply | Quote

As Steve noted, there is no event that fires when the user inserts or deletes rows or columns, but you might get some ideas from Capture Deleted Rows on the Daily Dose of Excel site.

Reply | Quote