clippertm
Reputation: 159
How do I make a for/next loop jump/skip values?
I want a loop in Excel VBA to iterate through values 1,2,4,5,6,7,8,9,10,11,13.
From 1 to 13, skipping 3.
Dim i As integer
For i = 1 To 13 "Skip 3"
...
Next i
Is that possible?
Upvotes: 0
Views: 2674
Answers (1)
Jean-François Corbett
Reputation: 38520
Dim i As integer
For i = 1 To 13
If i <> 3 Then
'Do stuff
Else
'Do nothing, or something else
End If
Next i
Upvotes: 1
Related Questions
- Skip to next iteration in loop vba
- For next Loop (beginner)
- VBA For Next Loop through a range
- For each loop to go to next row in iteration once value found in range
- How to skip to nth element of for next loop
- skip over a value in a loop and then continue to loop?
- move onto next iteration of loop in excel vba
- Skipping to the next cell in VBA in a for loop
- Advance to Next Item from Within a For-Next Loop
- how do i make excel vba move to the next cell in a for loop?