There is 1 section of my code where errors don't matter. I would like to use
On Error Resume Next
However, for the rest of the code, I'd like it to go back to recognizing errors.
===
More detail:
My code is copying the "Policies" worksheet and creating a "Policies2" worksheet.
I want to start the macro by deleting an existing "Policy2" if it exists. If it doesn't exist, then get on with the real work. I don't want the macro to tell me it can't find "Policies2"
On Error Resume Next
However, for the rest of the code, I'd like it to go back to recognizing errors.
===
More detail:
My code is copying the "Policies" worksheet and creating a "Policies2" worksheet.
I want to start the macro by deleting an existing "Policy2" if it exists. If it doesn't exist, then get on with the real work. I don't want the macro to tell me it can't find "Policies2"