Name
For...Next Statement
Syntax
Forcounter=initial_valueTomaximum_value _[Step stepcounter]'code to execute on each iteration[Exit For] Next [counter]
-
counter(required (optional withNextstatement); any valid numeric variable) A variable that serves as the loop counter
-
initial_value(required; any valid numeric expression) The starting value of
counterfor the first iteration of the loop-
maximum_value(required; any valid numeric expression) The value of
counterduring the last iteration of the loop-
stepcounter(optional (required ifStepis used); any valid numeric expression) The amount by which
counteris to be incremented or decremented on each 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 it also serves as a kind of flag
that indicates that the counter variable is to be modified.
Rules at a Glance
If
maximum_valueis greater thaninitial_valueand noStepkeyword is used or the step counter is positive, theFor...Nextloop is ignored and execution commences ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access