Skipping Loop

Hi, anybody can answer me why the MsgBox 2 and MsgBox 4 skipping on the below loop. please advice me to get this 2 & 4 without skipping.

Sub my_for_loop()
For i = 0 To 5
i = i + 1
MsgBox i
Next i
End Sub

you are incrementing the For Next counter within the loop.

Sub my_for_loop()
For i = 0 To 5
 ''''  i = i + 1
MsgBox i
Next i
End Sub

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code in [CODE] [/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here