Can't Select Worksheet

[guexc1977]

Hello,

Perhaps I'm a bit rusty here. I've changed a worksheet codename to "wsToC". Now I'm trying to select that worksheet in a subroutine as follows:

wsToC.Select

However, this is causing a 1004 error. Your help's appreciated.

 

[mikerickson]

Use the user interface to make the sheet in question the active sheet.
Then run this sub

Sub testing
    With ActiveSheet
        MsgBox "x" & .CodeName & "x" & vbcr & "x" & .Name & "x"
    End With
End Sub

What does that produce. Did any extra spaces get introduced into the names.

 

[RoryA]

If wsToC is the name of the sheet, like the default Sheet1, Sheet2 etc., then it is supposed to be within double quotes in the line

Sheets("wsToC").Select

The OP did already say it's the codename, not what appears on the tab.

 

[guexc1977]

Please note that we're all good. Excel was being finnicky but in the end, the syntax was correct and it operated as expected.

Thank you all.

 

[KolGuyXcel]

The OP did already say it's the codename, not what appears on the tab.

OOPS!! Missed that!

Let's wait for the results as suggested in post #11 !

 

[guexc1977]

No need to attempt to generate "results". It's now working without issue.

Thank you all again.