23Handling Errors

Errors are bound to happen. You can test and test 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

Get VBA and Macros for Microsoft Excel now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.