How to get the latest Excel formula functions like TEXTJOIN, CONCAT, MAXIFS, MINIFS, IFS and SWITCH to work on Excel 2007, 2010 and 2013?
The VBA Editor hasn't been updated for a very long time. Here are a few of my favorite tips to make your life easier.
I stumbled upon a rare feature one day, and it helped me tremendously. I recommend everyone try syntax highlighting in VBA Editor.
In order to make better apps, we need to write better code. Here are a few tips to help you improve your VBA.
Build configurations are essential when developing Office apps, such as COM add-ins. Here's how you can make them work for you!