Worksheet selection based on properties.idname 1

[Vashkar]

Worksheet:
has an id-number: 1
has a tabname: "Test" - properties: Name
has an id-name: Sheet1 - properties: (Name)

to select the worksheet:
Worksheets(1).Select
Worksheets("Test").Select
?

I need to reference the Sheet1 option, but I have no idea on the how.

Also I'm a bit stuck on finding documentation on it since all take in regard the Worksheets("[tabname]") and Worksheets([id-no.]).
I have no idea what the needed identifier is called as it's also shown as (Name) in properties. And that makes it a bit hard to find anything regarding.

Can anyone put me in the right direction, please?

 

[Vashkar]

Forgot to mention:
Working with Excel-2007

 

[SkipVought]

Hi,

Sheet1.Select

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[SkipVought]

That property is the CodeName property

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[Vashkar]

hahahaha, really that simple? OMG.
You don't want to know how many variants I've tried nót to come to that one.
Well, that's a good laugh at my own expense.

Thanks mate. Much appreciated.

 

[SkipVought]

I make a practice of using sheet CodeName quite a bit. I usually change the CodeName to something meaningful like wsData for a sheet containing my source data or wsPivot for a sheet with a PivotTable.

That way, even if the user changes the sheet name, my code works. The sheet CodeName can ONLY be change via VBA code or in the VBA editor.

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]