For...Next Statement


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

counter: Numeric variable used as a loop counter. The variable can't be an array element or an element of a user-defined type.

start: Initial value of counter.

end: Final value of counter.

step: Amount counter is changed each time through the loop. If not specified, step defaults to one.

statements: One or more statements between For and Next that are executed the specified number of times.

The step argument can be either positive or negative. The value of the step argument determines loop processing as follows:

Value	Loop executes if
Positive or 0	counter <= end
Negative	counter >= end

Once the loop starts and all statements in the loop have executed, step is added to counter. At this point, either the statements in the loop execute again (based on the same test that caused the loop to execute initially), or the loop is exited and execution continues with the statement following the Next statement.

Note
Changing the value of counter while inside a loop can make it more difficult to read and debug your code.

Exit For can only be used within a For Each...Next or For...Next control structure to provide an alternate way to exit. Any number of Exit For statements may be placed anywhere in the loop. Exit For is often used with the evaluation of some condition (for example, If...Then), and transfers control to the statement immediately following Next.

You can nest For...Next loops by placing one For...Next loop within another. Give each loop a unique variable name as its counter. The following construction is correct:

┬á	Copy Code
For I = 1 To 10 For J = 1 To 10 For K = 1 To 10 . . . Next Next Next

Version 1

Reference

Do...Loop Statement
Exit Statement
For Each...Next Statement
While...Wend Statement

Arguments

Remarks

Requirements

See Also

Reference