Run-time error '9' Subscript out of Range Help

[Pookiemeister]

I am getting a "Run-time error '9': Subscript out of range" on the following code:

Worksheets("Exhibit ""I""").Activate

The worksheet name is Exhibit "I". If I remember correctly about what that run-time error means, on this line of code its saying it can't find a sheet with that name to activate. I have a feeling it has something to due with all the quotes around the letter (I). Unfortunately, I can not rename this spreadsheet because it is within a public file on a server and I'm not the author of it. I tried different ways to change the worksheet name like adding in single quotes(') instead of double quotes(") but VBA would change that line of code to RED Letters. The only way I could rename the worksheet above so that entire line of code wouldn't be in RED Letters was to position the quotes as shown above. But it still gave me a Run-time error '9'. I never dealt with worksheet names with quotes in them so I'm at a loss on to fix this error. Thank you.

 

[Fluff]

I know it returns the Activesheet name and its length but how is this code used to debug(troubleshoot)? Thank You.

It shows that you have a space at the end of the sheet name (hence the inclusion of the | at the start & end).
Also I added the length of the string to show if there was 1 or more spaces inside the file name.
Try

Worksheets("Exhibit " & """I""" & " ").Activate

 

[Pookiemeister]

Thank you all very much for your help and for the troubleshooting/debug code tip.

 

[Fluff]

Glad we could help & thanks for the feedback

 

[Pookiemeister]

Quick question there is a second part to my code similarly to the above problem that I forgot to mention in the very first post. Do I need to create a new thread for this problem?
Sorry and Thank you.

 

[Fluff]

Yes please.