For...Next

Syntax

For Num = First To Last [Step Inc]

statements

Next [Num]

Description

Execute statements while Num is in the range First to Last.

Parameter	Description
Num	This is the iteration variable.
First	Set Num to this value initially.
Last	Continue looping while Num is in the range. See Step Inc below.
Inc	If this numeric value is greater than zero then the for loop continues as long as Num is less than or equal to Last. If this numeric value is less than zero then the for loop continues as long as Num is greater than or equal to Last. If this is omitted then one is used.

See Also

Do, For Each, Exit For, While.

Example

Sub Main

For I = 1 To 2000 Step 100

Debug.Print I;I+I;I*I

Next I

End Sub