you can go backward and use increments other than 1 : For « Language Basics « VBA / Excel / Access / Word
- VBA / Excel / Access / Word
- Language Basics
- For
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 | | |