If you regularly work with complex macros and code spreadsheets for them, then you probably pride yourself on your ability to write neat pieces of code to solve problems like supporting. However, a post on the official Excel blog points out that in many cases, you can get better results by emulating how you would solve the problem manually in a specific spreadsheet, and then generalising that for use in your macro. Hit the post for full details and code samples.