Activate/ go to a sheet with variable sheet name

[AJ12345]

Hi.

I have a workbook with about 140 sheets. I would like to have a macro that activates one of those sheets, based on their name selected from a drop down cell.

Example:
I have a drop down cell with pre defined names (for instance A, B or C). I have three sheets named the same (A,B or C). I would like to select A,B or C from the drop down cell and then run the macro so that the sheet with the same name gets activated.

This is a part of a larger macro..

Please help.

 

[circledchicken]

Hi,

You often don't need to select or activate sheets before working with them, but you can try something like this:

Sub example()


    Dim strSht As String
    
    strSht = Sheets("Sheet1").Range("A1").Value2
    Sheets(strSht).Activate ' or .Select


End Sub