5 ways to make better Macros in Excel - fewer errors, smoother coding, less fuss!
These 5 tips will bring you up to speed on what you need to know to make your programming life in VBA and Macros much easier.
These tips cover everything from how to use a Sub vs a Function procedure to preventing variables and values from unknowingly being changed in your code.
Run a Macro in Excel (Microsoft Link)