Error Handling

[student100]

I am trying to create a code that deletes a worksheet named "Optimisation" if it exists and create a new one under the same name, or simply create "Optimisation" if it doesn't exist.

I am aware that this will raise an error if the sheet "Optimization" does not exist. I followed the error tackling methods found at this site, however I am still unable to proceed after the second line which raises the error "run-time error: subscript out of range".

I am also trying to avoid the "run-time error: automation error", which comes up at random times while running my code. (I have read somewhere that this arises when multiple worksheets are open simultaneously, however I am only referring to one existing worksheet and the newly created "Optimisation" worksheet so I don't understand why I am getting this)

This is at the very top of my code (no other error handlers active on top of this part of the code):

Please Login or Register  to view this content.

Could someone please tell me why this is happening and how I will be able to fix this? Thank you.

[Kaper]

move negation in front of testing "whether object is nothing"

Please Login or Register  to view this content.

[Kaper]

BTW: Before adding new sheet, I'd recommend to restore strict error handling with

Please Login or Register  to view this content.

[rorya]

If you are seeing an error when you have an On Error Resume Next in operation, your VB Editor has been set to break on all errors. Change that under Tools- Options, General tab, to either Break on unhandled errors, or Break in Class module.

BTW, you don't really benefit from using a variable here - you can just do:

Please Login or Register  to view this content.

[student100]

Thank you Kaper and Rorya for your suggestions, I have tried them and am glad to see that they effectively countered the error I had at hand!