Lots of people use VBA, but not everyone uses it efficiently. Here are 7 things you should be doing when writing VBA code.
Continue Reading: 7 Things You Should Be Doing in VBA »
Documentation Best Practices for Web APIs
August 20, 2010 by · 
Programmable Web has a nice article called Web API Documentation Best Practices. It brings up several important points about how API developers should document their APIs. Consider this article a call to API developers — maintain your documentation!
Continue Reading: Documentation Best Practices for Web APIs »
Better Living Through Spreadsheets
August 6, 2010 by · In 12 Rules for Making Better Spreadsheets, Chandoo posts some reader tips. I'd like to add some more.
Continue Reading: Better Living Through Spreadsheets »
I promise
May 29, 2009 by · To improve my VBA code, I promise to do (or at least try to do) the following:
I promise to stop setting objects to Nothing. It's pointless code that doesn't actually reclaim memory or destroy objects. All it does is separate your object from the memory space holding its value.
Continue Reading: I promise »
Follow Me