How to conditionally color rows

[GIS2013]

Hi everyone,

I need to color in a different color each row, where I have more than 500 rows in my range.

The loop below stops after about ~50 rows. I guess this is because VBA have just about 50 different colors.

*My question: how to change the loop so it repeats the loop after finish the first 50 colors *

P.S. I don't mind to have again colorindex = 3 after 47 different colors.

Thanks!

Please Login or Register  to view this content.

[Andy Pope]

colour index is a value between 1 and 56.

you need to add a line to test value of ci and reset it within the loop

[GIS2013]

@Andy, can you please show me how to reset in from within?

I guess that it has to include:

Please Login or Register  to view this content.

[Andy Pope]

Please Login or Register  to view this content.

[GIS2013]

Many thanks