Refer to sheet by name stored in cell - Amend code

[tlc53]

Hi,

I have the below coding which works fine but instead of referring to the sheet named "Cordis", I would like it to get the sheet name from cell A12 (which has "Cordis" typed in it).

Private Sub CommandButton1_Click()
Application.ScreenUpdating = False
Sheets("Monthly Data").Select
CleanUp
Sheets("Cordis").Select
ClientNarrative
Sheets("Dashboard").Select
Application.ScreenUpdating = True
CommandButton1.Enabled = False
End Sub

I have tried

Sheets(Range("A12")).Select
ClientNarrative

And

Call Sheets(Range("A12")).Select
ClientNarrative

But neither seem to work. Can anyone see how I can get this working please? Thank you

 

[JoeMo]

See the modification to your code in bold red font below. Note A12 should contain "Cordis" w/o the quote marks.

Hi,

I have the below coding which works fine but instead of referring to the sheet named "Cordis", I would like it to get the sheet name from cell A12 (which has "Cordis" typed in it).

Private Sub CommandButton1_Click()
Application.ScreenUpdating = False
Sheets("Monthly Data").Select
CleanUp
[B][COLOR=#ff0000]Sheets(Range("A12").Value).Select[/COLOR][/B]
ClientNarrative
Sheets("Dashboard").Select
Application.ScreenUpdating = True
CommandButton1.Enabled = False
End Sub

 

[tlc53]

See the modification to your code in bold red font below. Note A12 should contain "Cordis" w/o the quote marks.

Perfect, thank you JoeMo!!

 

[JoeMo]

Perfect, thank you JoeMo!!

You are welcome - thanks for the reply.