Worksheet name

[starchildren3317]

I have a worksheet in my excel workbook called AppSelect. I have named it that way both by changed the name of the tab to AppSelect and by changing the name property of Sheet1 to AppSelect.

However, when I try to call the worksheet by its name in the code I get an error.

Worksheets(AppSelect).Activate

Error:

Runtime error 13:

Type Mismatch


Any Ideas?

 

[Jonmo1]

To use the CodeName, you simply use

AppSelect.Activate

To use the TabName, you use
Sheets("AppSelect").Activate 'With the quotes


Hope that helps.