I'm not sure what error you're writing about (in xl97), but I agree that you
should use that "on error resume next" sparingly. And turn it back to your
error handler (or goto 0) right after the code that may cause the error.



BizMark wrote:

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

--
BizMark

--

Dave Peterson