Seriously Excel? Change Row Colors

[Saladsamurai]

I am beginning to despise Excel more and more with each day.

I want to take a Worksheet and simply "highlight" every other row yellow.

My idea was to record a Macro and modify it. Here is the Recorded Macro:

[vba]Sub Macro1()
Rows("1:1").Select
With Selection.Interior
.ColorIndex = 19
.Pattern = xlSolid
.PatternColorIndex = xlAutomatic
End With
End Sub
[/vba]

And here is the Modification I made:
[vba]Sub Macro1()

For i = 2 to 100 Step 2

WorkSheets(1).Rows("i:i").Select
With Selection.Interior
.ColorIndex = 19
.Pattern = xlSolid
.PatternColorIndex = xlAutomatic
End With

Next i
End Sub
[/vba]

Why doesn't that work? It doesn't like the notation ("i:i") for some reason.

[Ken Puls]

Try this:
[vba]

Sub Macro1()

Dim i as Long

For i = 2 To 100 Step 2

With WorkSheets(1).Rows(i).Interior
.ColorIndex = 19
.Pattern = xlSolid
.PatternColorIndex = xlAutomatic
End With

Next i

End Sub

[/vba]