Excel 2016 VBA and Macros

4. Looping and Flow Control

In This Chapter

For...Next Loops

Do Loops

The VBA Loop: For Each

Flow Control: Using If...Then...Else and Select Case

Next Steps

Loops make your life easier. You might have 20 lines of macro code that do something cool one time. Add a line of code above and below, and suddenly your macro fixes a million rows instead of one row. Loops are a fundamental component of any programming language. If you’ve taken any programming classes, even BASIC, you’ve likely encountered a For...Next loop. Fortunately, VBA supports all the usual loops, plus a special loop that is excellent to use with VBA.

This chapter covers the basic loop constructs:

For...Next

Do...While

Do...Until

While...Wend

Until...Loop

This chapter also ...