Selecting Worksheet by it's value originally given

  • Thread starter Thread starter mike.wilson8
  • Start date Start date
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?
 
Hi

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


Arvi Laanemets
 
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,
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Reference(s) to worksheets for building graphs 4
Excel VBA - Problem with Closing Print Preview 0
Excel Already selected values from DropDown list dynamically updating on multiple sheets 10
Scrabble Value calculation for Welsh words 0
Can someone help me? (code here) 3
Vlookup and return sheet name also 2
Linq IQueryable to Listview 2
Inerting name of current worksheet into fuction 11

Back
Top