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 Goto -1
close
bars
angle-double-down
X
Username
Password
Remember me
Forgot Password?
Join Us
Login
Accessing this course requires a login. Please enter your credentials below!
Username or Email Address
Password
Remember Me
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