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 a

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.