XL2000: Worksheet_Change Event Triggered When You Delete Cells (235115)


The information in this article applies to:

  • Microsoft Excel 2000
This article was previously published under Q235115

SYMPTOMS

When you delete cells, Excel triggers the Worksheet_Change event, even though Excel Help file says that it will not.

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.

MORE INFORMATION

In the Microsoft Excel Visual Basic Editor (VBE), the "Change Event (Excel)" Help topic demonstrates the syntax for the Worksheet_Change event and includes this statement in the remarks:

Deleting cells doesn't trigger this event.

This statement is incorrect. Deleting cells triggers the Worksheet_Change event.
Modification Type:MinorLast Reviewed:10/11/2006
Keywords:kbbug kbpending KB235115
©2004 Microsoft Corporation. All rights reserved.