May 2008 Entries

Macro Guidelines for Excel VBA Beginners

I'm in the process of updating an Excel spreadsheet that is failing when it is running inside of Internet Explorer. The issue is related to the ActiveSheet and other global properties having a value of Nothing when the code is assuming they have valid references. As I am going through this spreadsheet, I am noting a wide variety of programming deficiencies and inefficiencies. Here is a list of some of the issues encountered: ...

posted @ Tuesday, May 27, 2008 6:28 PM | Feedback (0)