Chapter 11: Handling Errors
Try as you may, mistakes will be made. After all, we're only human. There are three types of errors in the VBA world of coding; syntax errors, compile errors, and runtime errors. Even experienced programmers encounter these problems to some extent. In the world of programming, errors are part of the territory, so consider yourself in good company.
The sooner you learn how to deal with all types of errors, the easier your life as a programmer will be.
In this chapter, we will cover the following recipes:
- Handling different types of errors
- Correcting a runtime error
- Testing to find errors
- Using the On Error statement
- Resuming after an error
By the end of this chapter, you will be able to do error handling in VBA. ...
Get VBA Automation for Excel 2019 Cookbook 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.
