Issues with concatenate a Worksheet name

[Merenat]

Hello everyone,

I need to refer a worksheet to modify some properties. My problem is that the name comes from a index value.

The sheet name is Template1(1) and is the sixth sheet.
Worksheets(cell + 5).Visible = True --> works fine and do the job, but how can I call by his name? If there were changes in the number of sheets, it would surely stop working.
Worksheets(("Template" & cell)).Visible = True --> Don't work
Worksheets(""" & cell &""").Visible = True --> Don't Work either.

What would be the correct way to call him? No matter how hard I try, I don't see it.

Thank you, have a nice day.

 

[CSmith]

In the VBA you can set the Name to what you need then deal with it using that name . . .

Then you can refer to it like this ...

    fileCreation = Now()
    sheetName = Format(fileCreation, "yyyymmddhhnnss") & "-" & Range("CustomerName").Value
    Template.Visible = xlSheetVisible
    Template.Copy After:=Worksheets(Worksheets.Count)
    ActiveSheet.Name = sheetName
    Template.Visible = xlSheetHidden
    Sheets(sheetName).Range("$A$1").PasteSpecial Paste:=xlPasteValues

 

[CSmith]

You can also call it via the other (Name) like my template page above. (Direct object reference)
The other Sheets(sheetName) is indirect via named sheet/index

 

[Merenat]

Thanks CSmith,
I think I have not explained well or I'm not understanding what you want to explain.

Cell is the value of the index, and changes between 1 and the last number.
The sheet tab name is 1,2,3... to match index. But if I refeer like :
Worksheets(cell).Visible = True
The changes are made in the Aux tab. I think I need to add the quotes to refer to the name in parentheses but i can't manage to add the cuotes in the code.

Thanks for your time and patience.

 

[Fluff]

How about

Worksheets(Cstr(cell)).Visible = True

 

[Merenat]

Thank you Fluff,

Works great and is elegant.

I mark it as solved.

 

[Fluff]

You're welcome & thanks for the feedback.