by Nate Moore | Aug 25, 2014 | Macros and VBA
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...
by Nate Moore | Aug 18, 2014 | Macros and VBA
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...
by Nate Moore | Aug 11, 2014 | Macros and VBA
There’s a way to programmatically define a range of cells to work with in Excel Video 422. I’m introducing loops, a way to repeat code a set number of times, in Excel Video 422. I’m also adding a few new functions as well, so I hope this isn’t too much for one video....
by Nate Moore | Aug 4, 2014 | Macros and 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...
by Nate Moore | Jul 28, 2014 | Macros and VBA
There are three very useful shortcuts in Excel Video 420. I’ll show you how to quickly comment and uncomment lines of code. For those of you who don’t write a lot of code, by comment I mean to have VBA skip over the line without running the code. You can use comments...