Microsoft KB Archive/235115

= XL2000: Worksheet_Change Event Triggered When You Delete Cells =

Article ID: 235115

Article Last Modified on 10/11/2006

-

APPLIES TO


 * Microsoft Excel 2000 Standard Edition

-



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.

Additional query words: XL2000

Keywords: kbbug kbpending KB235115

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.