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

Any help/ideas greatly appreciated

Try this

http://www.techonthenet.com/excel/qu...nd_format2.php



On Aug 2, 8:02 pm, M&M wrote:
How can i Color every other row in grey, in a dynamic range?

Any help/ideas greatly appreciated

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