Summary:  In the previous tutorial (#6 Collections) we got familiar with the idea of Excel VBA objects that are like parts of a house – but how can we use them to automate our processes? What if [...]

Summary: If you followed our Excel VBA tutorials 1 – 5, you’ll now have a good grasp of macro programming basics. It’s time to go deeper into the Excel VBA world to understand collections. Let’s [...]

Summary: In the first four tutorials of this series we learned the basics of programming Excel using the VBE (Visual Basic Editor), but most of the time we relied on macro recordings of Excel’s [...]

Summary: How do you make a macro recording more user friendly? Let’s say you want to get rid of all those “Activecell” and “FormulaR1C1” and similar lines of VBA code. In article #4 of this [...]

Summary: Don’t you just hate it when you run a recorded macro and it works so fast you can’t see what it’s doing? Especially when it does something you don’t want it to… why did it do this or [...]

Summary: Programming sure can make your life much easier. But to write useful Excel VBA code, you have to know hundreds of commands, right? Or is there a way to reduce the boring (sometimes [...]