Prevetning errors from causing a program to shut down

You know how you hate the debug error often runtime 13 or and out of place array. Well put this at the top of every function/sub you have

Code (Text):

1. on error goto errorhandeler

Then at the bottom of the sub/function put

Code (Text):

1.  
2. exit sub
3. errorhandeler:
4.  
5.             MsgBox (Err.Number & ", " & Err.Description)
6.    
7.  

YOu need the exit sub to make sure that the sud/function goess to the error handeler

 

Or, if you dont want anything to popup then just put "on error resume next" and when theres an error, nothing will happen. But I dont reccomend using it, people should use your way instead.

 

Nope this prevents shutdown also to esily sopy errors select the window and press ctr+c
---------------------------
MSP
---------------------------
13, Type mismatch
---------------------------
OK
---------------------------

 

does that mean you can do

Code (Text):

1. on error err.clear

and that would work too?
[/code]