Reversing "ON ERROR RESUME NEXT"

[Conradk]

Is there a way to turn "on error resume next" off? I have a line of code that bombs if the worksheet is empty. I want to use "on error resume next”, execute one line of code and then turn "on error resume next" off.

 

[Richie(UK)]

Hi,

Use "On Error Goto 0"

HTH

 

[onlyadrafter]

Hello,

DOes

on error goto 0

suit your needs?

 

[Jay Petrulis]

Hi,

In addition to the "On Error Goto 0," use "Err.Clear" to clear any errors and start anew.

On Error Resume Next
'
'
'
'
Err.Clear
On Error GoTo 0

 

[Conradk]

Many thanks to all!