printing alternating gray and white background

[K. Georgiadis]

I saw the VBA code for this a while ago but I can no
longer remember where;

I want to print an Excel worksheet with each row having
alternating white and light gray background. Can someone
help me, please?

 

[mzehr]

Hi,
See Chip Pearsons website

Alternate Row Colors
http://www.cpearson.com/excel/banding.htm

 

[Don Guillett]

try this. Adjust to suit

Sub colorrow()
For i = 1 To 300 Step 2
Rows(i).Interior.ColorIndex = 15
Next i
End Sub