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.

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

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