Simple Query

[T De Villiers]

I want to write a macro which highlights rows
21,23,36,29,34,35 ....

I am trying
For i = 21,23,36,29,34,35
cells(i,4).entirerow.interior.colorindex = 40
Next


Not quite there....
Thanks

[mudraker]

forget the For loop & use a single command - much quicker

Please Login or Register  to view this content.

PS. you can not use a for loop that way

for i = 20 to 30 step 1

or

for i = 20 to 30 step 2 ' increase by 2 (20, 22, 24 etc)

or

for i = 30 to 20 step -1 ' decrease by 1