Use of ON ERROR GOTO 0

[davidm]

I am beginning to divest myself of some bad programming habits I sort of picked up during my rookie days years ago. Towards this end, I am now questioning the use of ON ERROR GOTO TO 0 to follow and disable ON ERROR RESUME NEXT as in:

Sub test()
On Error Resume Next
Cells.SpecialCells(xlCellTypeFormulas, 23).Interior.color=vbyellow
On Error GoTo 0
End Sub

The above code (as in others I have tried) works perfectly with or WITHOUT "ON ERROR GOTO 0".

Now my question. Is ON ERROR GOTO TO 0 another of Visual Basic moribund lines of code which just clutter up space? Can't we do away with these vestiges?

David

[dominicb]

Good morning DavidM

It depends on what you're programming for. Try copying your code into a blank sheet, and turn your two error trapping routines into comments and run your code. You'll probably find it falls over. Now, enable the On Error Resume Next command, and run the code. This time it will appear that nothing happens. Your code has found a problem but ignored it. if you are programming for other people you might want to trap specific errors and return an appropriately worded msbox, but I find the On Error Resume Next an easy way to avoid the inelegant VBA "runtime Error" messages.

HTH

DominicB

[davidm]

Diminic,

Thanks for your reply. I appreciate the use of error trapping, not least the ON ERROR RESUME NEXT. What I need clarification on is the usefulness of ON ERROR GOTO 0. Put another way, is there any need to turn off the error trap before exiting the code? A case of superfluity?


David

[dominicb]

Hi David

I personally never use the On Error Goto 0 command (and can't recall seeing any other VBA coder use it frequently), because once the routine has run there is no need for error trapping, so it does not need to be used as a matter of course - only if you deliberately need to turn error trapping off for some reason.

HTH

DominicB