Weird counter question

[hegisin]

Hi,

I have the following loop:

For counter = 1 To Worksheets.Count - 1 Step 0.5

Worksheets(counter).Activate
counter = counter + 1
Call results
Next


In this case worksheets(counter) has the value 22

However, it only works if I set it to step 0.5.

If I use step 1 the the counter actually counts 2 and is jumping from sheets 22 to 20-18-16 etc.

Any idea why this is the case?

[raypayette]

You are incrementing the Counter twice. Here is the corrected code:
For counter = 1 To Worksheets.Count - 1 Step 1
Worksheets(counter).Activate
Call Results
Next

[hegisin]

Many thanks for that!