Select Page

Excel Video 424 Loops with Steps

Excel Video 424 shows you how to make your loop skip rows as it processes your code. Today’s example is a list of patients where I need to test a quality measure for every third patient. Watch how I can use Step to count by threes (1,4,7,10…) instead of shading every...

Excel Video 423 Introducing Loops

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...

Excel Video 421 Referencing Tables in VBA

Tables are a great way to manage Excel data. Excel Video 421 shows how to reference and change a Table using VBA. As we continue our discussion about how to reference data using VBA, it’s worth a few minutes to understand how to work with Tables. If you aren’t...