We’ll start discussing loops in Excel Video 423. Loops are an important concept in programming, and there are several different ways to create a loop in VBA. We’ll start with a basic For…Next loop that runs code a set number of times. To keep things simple, we’ll use one variable that I’ll call A, and we’ll use it several times throughout the macro. Watch how the macro runs until A hits the limit of 8 that we define in our loop.
We’ll make the macro a little more complicated in the next Excel Video. Thanks for watching.
