Reply to thread

Message: [QUOTE="Steve, post: 6390018"] Morning all. After month's of attempting to better understand error traps, I'm interested in one last option. The use of Case-Select with on error. Because we're processing over 6000 files with the macros many of you have helped us develop, we've found so far in our initial trials that there are a variety of errors we see. In order to catch as many of the errors as possible without interrupting our work flow I've been thinking about using Case-select with groups of the trappable error #'s as seen on the "trappable errors" list from the Excel Help file. My question here is- how do I set up the initial select statement? My initial thoughts are: Select Case err.number case 1 to 50 call MacroA case 51 to 100 Call MacroB .... ...... ... case 1000 to 1500 Call MacroN end select Some further clarification on the use of the err.number in this instance would be appreciated. Thank you. [/QUOTE]