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. Luckily, VBA supports all the usual loops, plus a special loop that is excellent to use with VBA.
This chapter covers the basic loop constructs:
We'll also discuss the cool loop construct unique to object oriented languages:
These are common loop constructs. Everything between
Next is run multiple times. Each time that the code runs, a certain ...