The information in this article applies to:
SYMPTOMSWhen you run a Microsoft Excel Visual Basic for Applications macro that contains a public variable, Excel reinitializes the public variable if an error condition halts the execution of the macro. This is different behavior from earlier versions of Microsoft Excel and Visual Basic for Applications. CAUSEThe mode that stops the code execution, but keeps the stack variables was removed. MORE INFORMATION
In earlier versions of Microsoft Excel and Visual Basic for Applications,
there is a mode in the internal code that stops the code execution but
keeps the stack variables. This is by design of Visual Basic for
Applications.
REFERENCESFor more information about public variables, click the Index tab or button in Microsoft Excel Help, type the following text variables, declaringand then double-click the selected text to go to the "Public Statement" topic. Additional query words: vbe XL97 XL98 vba
Keywords : kbprg kbdta KbVBA |
Last Reviewed: October 22, 1999 © 2000 Microsoft Corporation. All rights reserved. Terms of Use. |