VB & VBA in a Nutshell: The Language

For...Next Statement

Named Arguments

No

Syntax

For counter = initial_value To end_value _
             [Step stepcounter]
					

'code to execute on each iteration

[Exit For]
Next [counter]

counter

Use: Required (optional with Next statement)

Data Type: Numeric Variant

Any valid numeric variable to be used as the loop counter.

initial_value

Use: Required

Data Type: Numeric Variant

Any valid numeric expression that specifies the loop counter's initial value.

maximum_value

Use: Required

Data Type: Numeric Variant

Any valid numeric expression that specifies the loop counter's maximum value.

stepcounter

Use: Optional (required if Step used)

Data Type: Numeric Variant

Any valid numeric expression that indicates how much the loop counter should be incremented with each new iteration of the loop.

Description

Defines a loop that executes a given number of times, as determined by a loop counter. To use the For...Next loop, you must assign a numeric value to a counter variable. This counter is either incremented or decremented automatically with each iteration of the loop. In the For statement, you specify the value that is to be assigned to the counter initially and the maximum value the counter will reach for the block of code to be executed. The Next statement marks the end of the block of code that is to execute repeatedly, and also serves as a kind of flag that indicates the counter variable is to be modified.

Rules at a Glance

• If final_value is less than initial_value, and no Step keyword is used ...