Microsoft KB Archive/213442

= XL2000: Control Block Statement Error Messages =

Article ID: 213442

Article Last Modified on 11/23/2006

-

APPLIES TO


 * Microsoft Excel 2000 Standard Edition

-



This article was previously published under Q213442





SYMPTOMS
In Microsoft Excel, when you attempt to run a Microsoft Visual Basic for Applications macro or procedure, you may receive one of the following (or similar) error messages:

For without Next

End If without block If

Do without Loop

While without Wend

Select Case without End Select

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.



MORE INFORMATION
Microsoft provides programming examples for illustration only, without warranty either expressed or implied, including, but not limited to, the implied warranties of merchantability and/or fitness for a particular purpose. This article assumes that you are familiar with the programming language being demonstrated and the tools used to create and debug procedures. Microsoft support professionals can help explain the functionality of a particular procedure, but they will not modify these examples to provide added functionality or construct procedures to meet your specific needs. If you have limited programming experience, you may want to contact a Microsoft Certified Partner or the Microsoft fee-based consulting line at (800) 936-5200. For more information about Microsoft Certified Partners, please visit the following Microsoft Web site:

https://partner.microsoft.com/global/30000104

For more information about the support options that are available and about how to contact Microsoft, visit the following Microsoft Web site:

http://support.microsoft.com/default.aspx?scid=fh;EN-US;CNTACTMS

Visual Basic supports the following five types of control block statements:   For...Next Do While...Loop or Do...While Loop If...Else...End If  While...Wend Select Case...End Select In the above list of block types, the word or words preceding the ellipsis (...) begins a block, which is typically followed by one or more lines of macro code. These lines of code are then typically followed by the word or words following the ellipsis, which comprises the end of a block.

Sample Visual Basic Procedures
The following is an example of a macro (Sub procedure) that causes an error: Sub BadNestingExample If True Then For x = 1 To 5 End If   Next x End Sub Note that the indentation used above is for illustration purposes only. The macro above may be indented in such a way that the blocks of control statements appear correct.

If you attempt to run the above macro, you will receive the following error message:

End If without block If

The correct form of the code is as follows: Sub GoodNesting If True Then For x = 1 To 5 Next x   End If End Sub

Keywords: kbdtacode kberrmsg kbprb kbprogramming KB213442

-

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

© Microsoft Corporation. All rights reserved.