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
Using Line Numbers In VBA and The ERL() Function
Excel VBA Error Handling: Use Better, More Efficient Code, Fix Corrupt Files and Deliver Exceptional Results
Using Line Numbers In VBA and The ERL() Function
Previous Lesson
Back to Course
Next Lesson
X
Username
Password
Remember me
Forgot Password?
Join Us
