Activate A Sheet Based on a Cell in a Current Worksheet

[OilEconomist]

Thanks in advance for your help and I will let you know what it took to make it work.

I would like to activate a sheet based on the contents of a cell.

For example within Sheet "Simulation". Cell C3 contains "Evaluate1", I would like to activate that sheet. I tried the following, but I get a "Run-time error '9', Subscript out of range"

What's wrong with my code?

Cell

Sub Simulate ()[INDENT]
Dim SheetName As String

SheetName = Cells(3, 3).Value

Worksheet("SheetName").Activate[/INDENT]


End Sub

 

[Fluff]

Remove the quotes.

 

[OilEconomist]

Thanks for your assistance.

That didn't work either. Any other solutions as it gives the same error message?

 

[Fluff]

Make sure that the value in C3 is exactly the same as the sheet name, especially check for any leading/trailing spaces.

 

[OilEconomist]

Thanks so much! What you indicated was my issue.

 

[Fluff]

Glad to help & thanks for the feedback