Finding worksheets by using variable names

[Paul]

Hi,

Sheets are named "Jim" "Tom" "Judy" etc. The MASTER sheet
also has these names in a table. I want to click on a cell
containing "Tom" and have the code jump to the Tom sheet.

I tried this:
AAA=Activecell.value ' the cell contains word "Tom"
Sheets(AAA).select 'should find Tom sheet

But I get an error message, probably because VB is
expecting the AAA to be in quotes, and it's no recognizig
that AAA is a variable value.

Help appreciated
Paul

 

[Harald Staff]

Hi Paul

With a sheet named Tom this worked fine here:

Sub test()
Dim AAA As String
AAA = "Tom"
Sheets(AAA).Select
End Sub

But I get an error message, probably because VB is
expecting the AAA to be in quotes

No. What did the message actually say ?

Best wishes Harald