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?
|