CHAPTER 24Handling errors

In this chapter, you will:

  • Find out what happens when an error occurs

  • Do basic error handling with the On Error GoTo syntax

  • Get to know generic error handlers

  • Find out how to train your clients

  • Compare errors while developing with errors months later

  • Understand the ills of protecting code

  • Find out more about problems with passwords

  • Examine errors caused by different versions

Errors are bound to happen. Even when you test and retest your code, after a report is put into daily production and used for hundreds of days, something unexpected eventually happens. Your goal should be to try to head off obscure errors as you code. For this reason, you should always be thinking of what unexpected things could happen someday ...

Get Microsoft Excel 2019 VBA and Macros, First Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial