Delete Key Prevents Macros from Running

[bobmaucher]

I'm stuck on an issue I have with two different macro-enabled workbooks I'm building.

I have a Workbook_SheetChange event that runs each time I change the value of a cell within a certain range. It works fine, except when I press the delete key (to clear the contents of a cell in that range).

When I press delete, the SheetChange event doesn't register. Furthermore, once I press delete, any future changes to those cells also fails to start that SheetChange event.

The only way I've figured out to re-enable the macros is to quit and restart Excel.

Here's the code I'm using (within the ThisWorkbook object):

Please Login or Register  to view this content.

Any thoughts on what is causing this, or how to fix?? Thanks!!


-Bob

[bobmaucher]

Of course, after struggling with this for two hours, posting it made me see the solution.

IsEmpty(Target) is what the cell value is after I press delete, so that Exits the Sub.