Microsoft KB Archive/290640

= XL97: Change Event Is Not Triggered When You Delete Rows or Columns =

Article ID: 290640

Article Last Modified on 10/11/2006

-

APPLIES TO


 * Microsoft Excel 97 Standard Edition

-



This article was previously published under Q290640



SYMPTOMS
In Microsoft Visual Basic for Applications, when you use a Change event procedure on an Excel worksheet, the event is not triggered if you delete a row or column on the worksheet.



WORKAROUND
To work around this problem, try to use an alternate event, such as Worksheet_Calculate.



STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article. This problem no longer occurs in Microsoft Excel 2000.

Additional query words: XL97 worksheet_change row delete fire

Keywords: kbbug kbnofix KB290640

-

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

© Microsoft Corporation. All rights reserved.