if sheet name exists then exit sub - error

Hello,

I have this code then works when it enters the if statement but when the condition is not satisfied then it returns runtime error 9, subscript out of range. Why does it work when the condition is satisfied and not when it doesn't?

Please Login or Register  to view this content.

Trial name is a string and when the condition is satisfied then the messgage box apeared.

Thank you very much for the help. Have a nice day.

-Rob

& is forbidden chr in naming names

It's might be going into error because a sheet doesn't exist with that name which leads to a bigger question. Why on earth are you asking if an existing sheets name, has a name, which is it's name? Of course it is it's name.

It would be like going up to my friend Bob and saying; "Bob, if your name is Bob can you please pass me a beer".

If you are just trying to see if a sheet name exists there are other ways around it. Here is an example;

Please Login or Register  to view this content.

That worked great. Your analogy was perfect.

Thank you so much for your time. Have a nice day.

-Rob