Need macro to open a sheet that is named in a cell

[jtheat]

I have a sheet for each week of the year (Wk1 Wk2, etc). I use to use a macro that referred to a cell on a master sheet that would select that sheet. For example, in Cells F1 I have Wk12 entered. The macro would refer to that cell to find what sheet to open. I forgot the macro that would refer to Cells F1 and open the sheet name in that cell.

I am getting old... Help!

 

[Smitty]

Welcome to the Board!

Why do you need to select a sheet (you can often get by without selecting at all ).

But it would be Sheets(Range("F1").Value).Activate.

HTH,

Smitty

 

[jtheat]

Thanks

Penny,
It worked like a charm!

Thanks

 

[Smitty]

Penny,

Name's Smitty.

PennySaver's where I work.

Smitty

 

[jtheat]

Sorry Smitty.

 

[Smitty]

Sorry Smitty.

No worries mate!

Merry XMAS!

Smitty