Indeed. On Error Resume (Next) can be a nasty catch all.
Also - beware of using
On Error Resume (Next)
and
On Error Goto 0
in the same sub-routine (where you might want to ignore some errors but stop on others) - if an error is trapped by the former, an error occuring during the latter can cause an Illegal Operation error in Excel 97 (and possibly Excel 2000 - I think this was fixed in a later version).
BizMark
|