by Nate Moore | Sep 29, 2014 | Macros and VBA
Excel Video 429 introduces another way to loop through data with Do While Loops and Do Loops While. The difference between those two types of loops is where the While condition is. A Do While Loop may never run if the condition is never met, but a Do Loop While will...
by Nate Moore | Sep 22, 2014 | Macros and VBA
We’ve spent several Excel Videos looping through rows and columns in a worksheet. Excel Video 428 has a way to loop through Excel objects in your workbook. It’s easy to see the five worksheet names in this Excel workbook, but if you had 20 or 30 tabs, here’s a way to...
by Nate Moore | Sep 15, 2014 | Macros and VBA
If you find a problem as you’re looping through data, watch Excel Video 427 to learn how to stop the loop so you can fix the problem. Notice how we use an IF statement to check for blank statement dates. If we find a blank statement date, we use a message box to tell...
by Nate Moore | Sep 8, 2014 | Macros and VBA
Excel Video 426 is a practical example of nesting a loop inside another loop. Before I start, here’s a plug for MGMA’s Annual Conference in Las Vegas in October. You’ll find tons of real world examples of best practices from medical practices throughout the country....
by Nate Moore | Sep 1, 2014 | Macros and VBA
Excel Video 425 has one line of code that makes your macros much easier to run as the size of your data changes. Watch for how we create the FindEnd variable that finds the bottom row of your data, and then watch for how we use FindEnd to make our loop work. If the...
