Cell value as sheet name

[ChristineJ]

The value in cell C3 of the Mockup sheet is 1. For the simple code below, I'd like to know how to change the "1" in red (the sheet name) so that the value comes from C3 from the Mockup sheet. (Something like Sheets(Sheets("Mockup").Range("C3").Value).Select ​???)

Sub Cabin()


    Sheets("1").Select
    Range("A4").Select


End Sub

 

[Jonmo1]

You almost have it, this is a wierd little quirk of VBA.

Sheets are also Indexed...Numbered from 1 to xx (however many sheets you have)
So if you just happen to have a sheet named 1 (you right clicked the tab, and typed in 1 as it' name)
That is not necessarliy the same as the sheet with the index number 1.

Sheets(1) - this refers to the first sheet in the book
Sheets("1") - this refers to the sheet named "1"
They are not necessarily the same sheet.

The line you tried
Sheets(Sheets("Mockup").Range("C3").Value).Select
This would work with any non numeric sheetname, like "Sheet2"
But Sheets("Mockup").Range("C3").Value is being returned as a NUMBER, so you're getting the reference like
Sheets(1), but you want Sheets("1")

Try changing .Value to .Text

 

[ChristineJ]

Works perfectly with that change to .Text

Thanks so much for the explanation. My sheet names intentionally are numbers, and I did not realize the implications of using them. Appreciate your help!

 

[Jonmo1]

You're welcome