Selecting Worksheet by it's value originally given

M

mike.wilson8

Using this piece of code, I was able to name a worksheet by the value
in A1 in worksheet "Glist".

With ActiveSheet
.Name = Sheets("GList").Range("A1").Value
End With

Now I want to pull this worksheet up again,
but instead of doing a...Sheets("Test").Select.

I want
to do something like Sheets ("Glist").Range("A1").Value.Select. Make
sense?

I want to pull up the sheet by the value in A1, Sheet-Glist, but not
actually spell out the name. Can this be done?
 
A

Arvi Laanemets

Hi

....
SheetName=Sheets ("Glist").Range("A1").Value
Sheets(SheetName).Select
....


Arvi Laanemets
 
K

Kevin Lehrbass

Hi Mike,

I'm going to send you an excel file (zipped) that's related to your question.
It was actually the answer to someone else's question a while a go and then
I started playing around with it.
You can change the sheet name and file name by typing the value in the cell.

Cheers,
 
Top