Excel VBA 5 - Every Other Loop

Loading...

Sign in or sign up now!
Alert icon
Upgrade to the latest Flash Player for improved playback performance. Upgrade now or more info.
1,360
Loading...
Alert icon
Sign in or sign up now!
Alert icon

Uploaded by on Jul 9, 2010

Have a loop hit every other row instead of every row using the Step command.

Category:

Science & Technology

Tags:

License:

Standard YouTube License

  • likes, 0 dislikes

Link to this comment:

Share to:
see all

All Comments (1)

Sign In or Sign Up now to post a comment!
  • 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

Loading...

Alert icon
0 / 00Unsaved Playlist Return to active list
    1. Your queue is empty. Add videos to your queue using this button:
      or sign in to load a different list.
    Loading...Loading...Saving...
    • Clear all videos from this list
    • Learn more