View Single Post
  #4   Report Post  
BizMark BizMark is offline
Member
 
Location: London
Posts: 78
Default

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