Sub everyother()
For i = 1 To 100 Step 2
Cells(i, 1).EntireRow.Interior.ColorIndex = 48
Next
End Sub

adjust the limits to suit the range.
--
Gary''s Student - gsnu200735


"M&M" wrote:

How can i Color every other row in grey, in a dynamic range?

Any help/ideas greatly appreciated