For…Next

For and Next are built-in functions that implement an incrementing loop in a Math worksheet. The section of script included in the loop begins with the For() call and ends with the Next notation. The Next notation directs back to the beginning of the loop.

Syntax

For(numInitialValue, numFinalValue, numStep)

numInitialValue

The initial or starting value of the loop.

numFinalValue

The final or ending value of the loop.

numStep

The step or increment value.

Return value

This function returns the current value of the loop.

Notes

This type of For…Next loop can be used only in Math worksheets. It cannot be used in any Command animation, VBScript interface, or Python script interface. When you are using VBScript, you should use that language's own tools for looping. For more information, see Looping Through Code.

You must partner every For() call with a Next notation, although you may have any number of worksheet rows between them. And as shown in the example below, you must place the Next notation in the Tag Name column of the worksheet.

The loop ends when its current value exceeds the value of numFinalValue. Specifically, each time the worksheet is executed and the Next notation is encountered, the following happens:

1. The value of numStep is added to the current value of the loop;

2. The execution returns to the For() call at the beginning of the loop; and

3. The current value of the loop is compared to the value of numFinalValue. If the current value is less than or equal to numFinalValue, the loop is executed again. If the current value is greater than numFinalValue, the loop is skipped and execution resumes with the first row after the Next notation.

Examples

Example of For…Next loop in a Math worksheet