Skip or trap errors depending on cell value

[derekpegg]

I want to be able to either trap errors in my code or skip errors using "on error resume next" depending on the value of a cell (0 or 1). I have put the following code in at the beginning of my macro:

If Sheets("Report Creation").Range("f7") = 1 Then On Error GoTo ErrHandler Else 
On Error Resume Next

But this does not seem to work and always "resumes next" as I guess this comes after the ErrHandler line. Any ideas on how I can do this?

Thanks in advance

 

[DominicB]

Good morning derekpegg

How about :

If Sheets("Report Creation").Range("f7") = 1 Then
On Error GoTo 0
Else
On Error Resume Next
End If

HTH

DominicB

 

[derekpegg]

Dominic

If Sheets("Report Creation").Range("f7") = 1 Then
On Error GoTo ErrHandler
Else
On Error Resume Next
End If

I used your code (but replaced with ErrHandler line) above and it seems to work. Funny thing is the code looks more or less same as my original code to me, just a couple of extra line breaks. Sure there's a good reason for it - I'll just keep on learning. Thanks for the help!