different color for even and odd rows

[tomvdduin]

Hi,

Does someone know how to set a different color for each even and each odd row in VBA? there isn't someting like a rowcounter that I can use to see if it's an even or an odd row, right?

thanks!

Tom

 

[BobJacksonNCI]

Select the FAQs tab near the top of this window...



HTH,
Bob

 

[CosmoKramer]

faq703-2684

Hoc nomen meum verum non est.

 

[tomvdduin]

Thanks... just what I was looking for!