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.

 

[KolGuyXcel]

If the name of the sheet is "wsToC" try

sheets("wsToc").select

 

[RoryA]

Is the sheet visible?

 

[guexc1977]

The sheet is visible and this -

Sheets(wsToC).Select

causes a "Type Mismatch".

Thank you again.

 

[RoryA]

Are you sure it's visible when the code is running? What is the actual error message?

 

[guexc1977]

Thanks, Rory.

It's definitely visible. Error is:

Run-time error '1004':
Method 'Select' of object '_Worksheet' failed

 

[RoryA]

What's the full code then, please?

 

[guexc1977]

That's really the only line. I'm just trying to select the worksheet.

Thank you again.

 

[RoryA]

It can't be the only line. What routine is it in?

 

[KolGuyXcel]

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