Crash Course: Excel VBA Macros For People Who Don’t Care About Excel VBA Macros

Every 6-9 months I have to write some macros in Excel. I spend most of my coding time working in C++, C# and PHP and I tend to forget both VBA syntax and the Excel API really easily. So for those of you who believe – like me – that coding in VBA is anathema, I’ve thrown together a quick crash course in how to get some common tasks done with no fuss. All the examples in this article deal with writing formula macros and I’ll assume you know how to use Excel’s interface and are familiar with using formulas. In the latter part of the article, I give a few code examples for performing common tasks required by Excel macros.