Excel VBA Error Handling: Use Better, More Efficient Code, Fix Corrupt Files and Deliver Exceptional Results
Intro
Intro
When To Use Error Handling In Excel VBA (and When Not To)
On Error Statements To Fight The Evil Errors!
On Error Resume Next
On Error Goto 0
On Error Goto -1
Redirect To a Custom Label Using 'On Error Goto'
The ERR() Object
The ERR() Object
Using Line Numbers In VBA and The ERL() Function
A Trick To Number Your Macro Lines Easily!
Raising Your Own Errors For Testing (and When To Raise Them)
Customize Errors
Logging Errors To A .Txt or .Err File
Email Errors With Outlook (Optional)
Circular Dependencies Between Modules: What The Heck?!
Help For Specific Errors/Issues
Windows API Declaration Issues (and Tips)
64 Bit Excel VBA Issues
Compiling A Project, Dealing With Syntax Errors
Dealing With Compile Errors
Error Trapping Settings
Heal Corrupt VBA With The VBA Code Cleaner (Invaluable, Yet FREE)
Utilizing Error Numbers and Descriptions
Previous Lesson
Next Lesson

On Error Resume Next

closebarsangle-double-down
X

Forgot Password?

Join Us

Login
Accessing this course requires a login. Please enter your credentials below!

Lost Your Password?
Register
Don't have an account? Register one!
Register an Account
linkedin facebook pinterest youtube rss twitter instagram facebook-blank rss-blank linkedin-blank pinterest youtube twitter instagram