How to do: "for loop decrement vba"

For loops, while loops, reverse loops, for each loops, double and multidimensional loops.

Below we will find an example of how to decrement loop in vba, or so called reverse looping. It really works the same way as a normal for loop where the step is assigned. Please find the identical results below in the excel prints. However, the latter one started from cell A10 versus the first that started from cell A1.

Looping to 10 step 1

Sub Loop1 ()

'Clears any previous content in the sheet. 
Cells.Clear

'Steps 1 cell each time and prints it in column A. (1,2,3...10)
For i = 1 To 10
    Cells(i, 1) = i
 'Range("A"&i), this the same thing.
Next i

End Sub

Reverse or decrement Looping

Sub LoopReverse()

Cells.Clear

'Steps -1 each time and prints it in column A.
'The result is exactly the same as our first loop. 
'However, this is printed in the reverse order starting from A10.

For i = 10 To 1 Step -1
 'This will print in reverse order.
    Cells(i, 1) = i
Next i

End Sub