For Loop Increments 1

[VincentCrimmins]

Hi,

I'm creating a For Loop to run some calculations, but I want the loop to go up in increments of 2 instead of 1, is this possible?

Thanks!

 

[HarleyQuinn]

Use STEP, e.g.

Dim i As Integer
  
  For i = 1 To 10 Step 2
   ' your code
  Next i

Hope this helps

HarleyQuinn
---------------------------------
The most overlooked advantage to owning a computer is that if they foul up there's no law against wacking them around a little. - Joe Martin

Get the most out of Tek-Tips, read FAQ222-2244 before posting.