Loading...
Uploaded by bjele123 on Jul 9, 2010
Have a loop hit every other row instead of every row using the Step command.
Science & Technology
Standard YouTube License
Couldn't read the script mess until i got it right
Sub ColorEveryOtherRow()
FinalRow = Cells(Rows.Count, 1).End(xlUp).Row
For l = 2 To FinalRow Step 2 Cells(l, 1).Resize(1, 6). _ Interior.ColorIndex = 35
Next l
End Sub
Acewolf2000 4 months ago
Load more suggestions
Couldn't read the script mess until i got it right
Sub ColorEveryOtherRow()
FinalRow = Cells(Rows.Count, 1).End(xlUp).Row
For l = 2 To FinalRow Step 2 Cells(l, 1).Resize(1, 6). _ Interior.ColorIndex = 35
Next l
End Sub
Acewolf2000 4 months ago