VBA Loops - For, Do-While and Do-Until Loops

Excel VBA Tutorial Part 6: VBA Loops - The For, Do-While and Do-Until Loops ... In this example, the step size is specified as -1, and so the loop sets the variable, i, to have the values, 10, 9, 8, ..., 1 in turn.

excelfunctions.net