View Single Post
  #1   Report Post  
Felix
 
Posts: n/a
Default VBA ON ERROR does not work with SPECIALCELLS

I have a problem trapping errors using
"On Error goto ..." or "On Error Resume Next"

"On Error ..." works everywhere except when the offending
command uses SpecialCells as in
Selection.SpecialCells(xlCellTypeBlanks).Select

when not found, the macro errors with Run-time error 1004.

The same macros worked fine in xl2000 until I had to
install the hotfix from MS Support article 815406. Then
the problem started. Just upgraded to xl2003 but the
problem remains.

All the MS support articles refer only to protected sheets
which does not apply. Any ideas on a workaround?