Control Block Statement Error Messages (124887)
The information in this article applies to:
- Microsoft Excel for Windows 5.0c
- Microsoft Excel for the Macintosh 5.0
- Microsoft Excel for the Macintosh 5.0a
- Microsoft Excel for Windows 95 7.0a
- Microsoft Excel 97 for Windows
- Microsoft Excel for Windows 95
- Microsoft Excel for Windows 5.0
- Microsoft Excel 98 Macintosh Edition
This article was previously published under Q124887 SYMPTOMS
In Microsoft Excel, when you attempt to execute a Microsoft Visual Basic
for Applications macro or procedure, you may receive one of the following
error messages:
Microsoft Excel will also highlight part of your code in an attempt to
indicate where the syntax error occurred. In some cases, the highlighted
code may not match the syntax displayed in the error message.
CAUSE
The most likely cause for these error messages is that your code contains
control block statements that are incorrectly nested. That is, a statement
that begins a control block is used without the corresponding statement
that ends the control block.
However, another less obvious situation may occur. That situation occurs
when one block, for example block A, begins inside of another block, for
example block B, but block A terminates outside of block B.
Modification Type: | Minor | Last Reviewed: | 10/11/2006 |
---|
Keywords: | kbdtacode kbinfo kbProgramming KB124887 |
---|
|