Invalid 'for' loop control variable

You created a For...Next loop that has the same control variable as a loop it is nested inside. Alternately, you may have created a For...Next loop with an illegal control variable. 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

• Rename the control variable in your For...Next loop to something unique within the scope of the outermost loop.

Looping Through Code | For...Next Statement | Do...Loop Statement


Exit Statement | For Each...Next Statement | While...Wend Statement