Business Solutions VBA and Macros for Microsoft® Office Excel® 2007

Chapter 25. Handling Errors

IN THIS CHAPTER

What Happens When an Error Occurs	529
Basic Error Handling with the On Error GoTo Syntax	532
Generic Error Handlers	534
Train Your Clients	536
Errors While Developing Versus Errors Months Later	537
The Ills of Protecting Code	539
Password Cracking	539
More Problems with Passwords	540
Errors Caused by Different Versions	541
Next Steps	541

Errors are bound to happen. You can test and retest your code, but after a report is put into daily production and used for hundreds of days, something unexpected will eventually happen. Your goal should be to try to head off obscure errors as you code. Always be thinking of what unexpected things could someday happen that would make your code not work.

What Happens When an Error Occurs