capturing row delete

This will capture when any row less than row 2000 is deleted, when put in the sheet's code module. However, the Calculate event won't be triggered unless there is a formula on the sheet.

Please Login or Register  to view this content.

If the formula =COUNTA(A:A) is somewhere on the page, this will trigger when a row is either added or deleted above row 2000.

Please Login or Register  to view this content.

The key to this is finding the functions to trigger the Calculate event. COUNTA(A:A) is excelent since it recalculates whenever a cell is removed or added to column A.