Correcting a runtime error
Runtime errors are by far the most common type of error you'll come across when working in VBA. As the name suggests, these errors only occur once you run the code. Unlike with syntax and compile errors, there is no way for VBA to check your code for actions that will happen after the procedure starts running.
To come up with a list of possible runtime errors is virtually impossible because situations and procedures are never the same.
One typical runtime error that occurs from time to time is when you create a link to an external file, and then accidentally delete that file. Only when you run the code will an error message be displayed. Another example is when you refer to a range that does not exist.
In this recipe, we will be correcting a runtime error.
Getting ready
Make sure that ErrorHandling.xlsm
from the preceding recipe is still open. Sheet1 should be active. Press Alt + F11 to switch to the VBA Editor. If it is not open, double...