printing alternating gray and white background

K

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?
 
D

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
 
Top