{{getMsg('Help_YouAreHere')}}: / {{page.title}} {{page.title}}

For/Next loopbasicsyntax

The For/Next loop provides a compact way to execute one or more statements a specified number of times. This block of statements will be executed until "i" is equals to the defined "endvalue".

A For/Next loop can be left with the Exit For statement.

Usage:

For i = //(startvalue)// To //(endvalue)// Step //(stepsize)//
    //(statement)//
next i

Examples:

Dim i
For i = 1 To 10 Step 1
    formula = formula + "a"
Next i