Quality, Affordable & Flexible
Take advantage of our Microsoft Office Series public courses’ Buy 2 Get 1 FREE package!!
Trapping errors are important as users can do marvelous things to mess up you macros. Here you can use either of these 2 statements.
- On Error Resume Next OR
- On Error Goto ErrorTrap1
... more lines of code
... more code (what to do if there is an error)
The first statement will allow the macro to continue the next line of code upon hitting an error but the second statement will run an alternative code should there be an error.