Select Page

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 row. Also notice how I use the variable b to not just shade the first column, but to put text in the second column as well.
Stepping is great, but wouldn’t it be nice to not have to count how many times you want the loop to run before running the loop each time? Next time we’ll count the number of rows to automatically figure out how many times the loop needs to run.