Expected 'To'

You created a For...Next loop, but did not include the To keyword in the first line. The first line of a For...Next loop must include the To keyword. The following demonstrates the correct structure of a For...Next loop.

                      For counter = start To end [Step step]
    [statements]
    [Exit For]
    [statements]
Next

To correct this error

  • Make sure that the For...Next loop includes all the necessary parts.

See Also

Reference

For...Next Statement

For Each...Next Statement

Do...Loop Statement

Exit Statement

For...Next Statement

While...Wend Statement