Do without Loop

  • Article

This page is specific to the Visual Basic for Applications (VBA) Language Reference for Office 2010.

Each Do must be matched with a terminating Loop. This error has the following cause and solution:

  • A Do statement was used without a terminating Loop statement. Check that other control structures within the Do...Loop structure are correctly matched. For example, a block If without a matching End If inside the Do...Loop structure may generate this error.

For additional information, select the item in question and press F1 (in Windows) or HELP (on the Macintosh).