Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

  1. Home
  2. XL2000: Worksheet_Change Event Triggered When You Delete Cells

XL2000: Worksheet_Change Event Triggered When You Delete Cells

View products that this article applies to.

This article was previously published under Q235115

↑ Back to the top

Symptoms

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

↑ Back to the top

Status

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

↑ Back to the top

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.

↑ Back to the top

Keywords: KB235115, kbpending, kbbug

↑ Back to the top

Article Info
Article ID : 235115
Revision : 5
Created on : 10/11/2006
Published on : 10/11/2006
Exists online : False
Views : 195