Odd Error Handling Behaviour; goes to error handler even when no error?

[kalikj]

I am using a macro that creates a new worksheet, and copies the existing visible worksheet range into that new worksheet; the code then asks the user to rename the new worksheet. I have an error handling procedure that should be activated only when there is an error; i.e. when the user tries to give a new / copied sheet the same name as an existing one. However when I execute the code, it goes into the error handling procedure even when there is no error, necessitating the naming of a worksheet twice in order for the code to complete! I have been banging my head against a brick wall and just cannot see what I am doing wrong! Please can you help.

Code as follows:

Please Login or Register  to view this content.

Thank you in advance,

Best regards,

Jason

[Richard Buttrey]

You've forgotten the

Please Login or Register  to view this content.

Immediately before the ErrHandler line

[TMS]

RB beat me to the solution to the stated problem. However, if there is a genuine error, there's not much point using an InputBox to ask for an alternative as you just drop out of the bottom of the macro anyway. You really need a mechanism for looping back, maybe x times (x = 2, 3, 4, whatever).

[kalikj]

Richard, Thank you, DOH! It seems to be that the simplest errors are sometimes the hardest to spot! One of Confucius's many laws methinks! Thank you once again, problem solved.

[kalikj]

Thank you for your input also TMS, I will take your point on board.

[TMS]

You're welcome.



If you are satisfied with the solution(s) provided, please mark your thread as Solved.


New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save


You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.