Category: Macros

If you’ve ever repeated the same actions multiple times in a spreadsheet, you’ll benefit from recording a macro to automate those tasks. But, once you have a macro, how do you access it? The easiest way is to add a macro button to your spreadsheet, for which Excel offers three…

Does your code need to execute the same action more than once? Instead of programming it multiple times, try writing it once and repeating it with a loop. Excel offers several different loop structures, depending on the conditions under which it should execute. Check out the table below to see…

Last week, the feature was for the advanced Excel users who are not programmers and new to VBA.  This post continues that theme.  The Immediate Window Is Your Friend The Immediate Window is where you can test code against current data and see the results. Use this to make sure…

For the advanced Excel users who are not programmers and new to VBA It’s inevitable. If you are an Excel power user, you will reach a point where formulas and the built-in Macro Recorder just aren't enough. When that happens, VBA (Visual Basic for Applications) macros may be just the…