Excel VBA Worksheet_Change Event Is Not Triggered When Last Row of Table is Deleted!

DanBurleson 1 Reputation point
2022-09-27T19:18:07.987+00:00

245206-demoexceltabledeletebug3.gifSimple to recreate with a single MsgBox in the Worksheet_Change sub and a table with two rows. Deleting all but the last row triggers Worksheet Change, but deleting the last one does not. There are no application events disabled. Only one line of code. A MsgBox.

Office Development
Office Development
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Development: The process of researching, productizing, and refining new or existing technologies.
3,459 questions
{count} votes