Row Property Example

This example makes every other row green in the current region for cell A1.

For Each rw In Spreadsheet1.Cells(1, 1).CurrentRegion.Rows
    If rw.Row Mod 2 = 0 Then rw.Interior.Color = "lightgreen"
Next