On Sat, 1 Nov 2003 22:37:09 -0500, Tom Ogilvy <[email deleted] wrote:

VBA code isn't needed.

Select all the columns

Use formatting = Conditional formatting


condition 1

Formula is =mod(row(),2)=0
Pattern is yellow

condition 2
formula is = Mod(row(),2)=1
Pattern is gray

It should be noted that this would be a hell of a lot faster than using
VBA.
--
auric "underscore" "underscore" "at" hotmail "dot" com
*****
Stupidity is no excuse for not thinking.