value of i in a for next loop (even/uneven)

[Hein]

Hi all

In my procedure I have a for ... next loop with "For i = 1 to Number"
How can I determine the value of i during this loop.
Whenever i is uneven some cell have to change color, if i is even cells remain unchanged.

I have most of the code figured out, except for this part

Who can help me?

Thanks in advance
Hein

[arthurbr]

Hi Hein,
I suppose that by "uneven" ( oneven) you mean "odd"?

[royUK]

Try posting your code for better help, However try this

Please Login or Register  to view this content.

[Hein]

I think this will work
Thank you Roy!!
Hein

PS
Arthur:
I did indeed mean odd, sorry for my bad English

[royUK]

I think this will work
Thank you Roy!!
Hein

PS
Arthur:
I did indeed mean odd, sorry for my bad English

If it works please let us know by marking the thread solved & rating the answer(s)

No problems with your english

Without knowing what you are doing, you might be able to change the colours with Conditional Formatting

[mudraker]

If you are only interested in your loop to colour every 2nd cell another option
is to use Step of 2 with the For command

Please Login or Register  to view this content.

[royUK]

If Mudraker is right then Chip Pearson shows hhow to achieve this

[Hein]

Thanks all for your help

I have set the post to solved, but can't find how to rate it
How can I do this?


Hein

[royUK]

Select the answer and click on the small icon on the top right that looks like a set scales