| 1. | Spelled something wrong (may be most common error) |
| 2. | Syntax Error |
| 3. | Space convert number or date to string |
| 4. | Timing Issues |
| 5. | Slow code |
| 6. | Hardcoding |
| 7. | Works on your machine but not on users |
| 8. | Can't stop code - add DoEvents to loops |
| 9. | Dialog box showing - application.displayalerts = false |
| 10. | Links to one or more external sources |
| 11. | Hard to solve Syntax errors |
| 12. | Compile error ByRef argument Type Mismatch when calling subroutine or function put ( ) around calling value |
| 13. | Quote within a Quote use two quotes "" |
| 14. | Missing Error Handling |
| 15. | Upper/Lower Case Issues |
| 16. | Global variable changed by called routine |
| 17. | Status bar not updating - add DoEvents |
| 18. | Workbook too large |
| 19. | Using a reserved word in code |
| 20. | Event executes and you don't want it to - application.enableEvents = false |
| 21. | Stop Spreadsheet from flashing - Application.screenupdating = False |
| 22. | Untrimmed Input |
| 23. | Number vs. Date vs. Character and leading single quote (') |
| 24. | Re-entry issue and using application.enableevents = false |