Worksheet with variable name

[morrisgr]

Hi.
I don't think my query will cause any of you guys much difficulty.
I want to activate a sheet named "Num-4".

I've tried many variations........unsuccessfully.
What am I doing wrong??
Thanks for any assistance you can provide
Morris

Sub ChooseSheet()

' I want to activate Sheet Num-4. The variable Num-4 is Formatted as Text in the same Workbook.

Dim actcell As String

Range("E4").Select 'This cell contains "Num-4"

actcell = ActiveCell


Worksheets(actcell).Activate


End Sub

 

[Fluff]

What error do you get with that code?

 

[morrisgr]

Hi.
Error says................."Subscript out of range"
Morris

 

[Fluff]

In that case you don't have a worksheet with the same name as the value in E4.

 

[morrisgr]

Hi.
Attached are 2 screenshots, one showing the sheets and another where I created the sheet names from.
The second image used "=CONCATENATE(A4,B4) " and then, I thought the format might be causing the problem, so I 'Copied and Pasted Special......"Value" into column E
Hope that helps.

 

[Fluff]

As I said

you don't have a worksheet with the same name as the value in E4.

All your sheets start No not Num

 

[morrisgr]

OUCH!!!!
Couldn't see the wood for the trees.
Sorry to have wasted your time............it's very hot here in Spain.
Many thanks
Morris

 

[morrisgr]

Was that the 'daftest' query you've ever had?
Morris

 

[Fluff]

You're welcome & thanks for the feedback.

Was that the 'daftest' query you've ever had?

Not by a long shot.