Selecting Worksheet by it's value originally given
 

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?

Selecting Worksheet by it's value originally given
 

Hi

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


Arvi Laanemets



wrote in message
oups.com...
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?

Selecting Worksheet by it's value originally given
 

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,
--
Kevin Lehrbass

www.spreadsheetsolutions4u.com


"Arvi Laanemets" wrote:

Hi

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


Arvi Laanemets



wrote in message
oups.com...
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?