you can go backward and use increments other than 1 : For « Language Basics « VBA / Excel / Access / Word






you can go backward and use increments other than 1

 
Sub ReverseForNext() 
    Dim n As Integer 

    For n = 50 To 1 Step -2 
        Debug.Print n 
    Next 
End Sub 

 








Related examples in the same category

1.For Loops with different steps
2.For...Next Loop
3.The For...Next construct is used when you have an exact number of iterations you want to perform
4.For loop whose step is 2
5.Checks values in a range 10 rows by 5 columns
6.Nest if statement into a for statement
7.Iterates six times outputting the numbers 0, 2, 4, 6, 8, and 10 in a message box:
8.iterates four times outputting the numbers 0, 3, 6, and 9 in a message box:
9.the loop iterates just three times outputting the numbers 10, 5, and 0 in a message box:
10.Non integer step for loop