Using the On Local Error Resume Next will only provide error trapping to the immediate function/sub. It will not be used if a subsequent error occurs outside of the function/sub.
Here's what Microsoft says about it...
"If local error-handling is not enabled in a procedure and an error occurs, control is passed back through the call stack until a procedure with error-handling enabled is found and the error is handled at that point. If no procedure in the call stack is found to have error-handling enabled, an error message is displayed at that point and execution stops or the host handles the error as appropriate."
HTH,
Mapman Assume nothing, question everything, be explicit not implicit, and you'll always be covered.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.