Skipping iterations in for loops

[Glory]

I've seen this before, but I can't remember how to do it.

For i = 1 to 3
'code
Next

How do I skip, for instance, iteration 2?

Edit: Using i as a variable in the code as well as a counter, which is why this matters.

 

[njimack]

For i = 1 to 3 Step 2

 

[Glory]

It's weird that didn't occur to me.

What if I only wanted to skip a single iteration?

"For i = 1 to 5", where "4" is skipped.

Is that possible without "If i = 4 then goto label" with the "label:" at the Next statement?

 

[njimack]

It's weird that didn't occur to me.

What if I only wanted to skip a single iteration?

"For i = 1 to 5", where "4" is skipped.

Is that possible without "If i = 4 then goto label" with the "label:" at the Next statement?

For i = 1 to 5
If i <> 4 Then
'your code here
End If
Next i

 

[Norie]

You don't need the Goto.

For I = 1 To 10
   If I<>4 Then
      ' Do stuff
      Debug.Print I
 
   End If
Next I

If there's more than 1 value you want to skip then you could expand the If or perhaps use Select case.

Though, it might be worth considering some other type of loop.

 

[Glory]

Thanks njmack.

Norie, this is pure curiosity not a problem I'm tackling anymore, but do you have any suggestions on the other kinds of loops?

I know Do/Loop, For/Next, using labels and goto, and calling external subs or functions for use in expressions.