VBA using a cell reference on one sheet to go to another sheet

[gberg]

I have a spreadsheet that has tabs for every week of the year. The tab names go; 2022-01-02, 2022-01-09, 2022-01-16, etc.

I have a control sheet (Named "Changes")that has a cell to reference which week a macro taht will use this cell reference to pick the tab to go to

Cell G1 on the "Changes" tab will control which tab the macro should go to

I've tried this but it does not work and I'm at a loss so hoping someone could help

Dim ShtName As String
ShtName = Range(Text(G1, "yyyy-mm-dd"))
Sheets(ShtName).Select


Thanks,

Greg

 

[Anthony47]

Changing to ShtName = Format(Range("G1").Value, "yyyy-mm-dd") should do the job

Bye

 

[gberg]

Anthony,

Thats awesome! Thanks so much for your help!