Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
VBA code to Add data to exsiting worksheet | Excel Discussion (Misc queries) | |||
macro to copy and edit then delete a worksheet | Excel Discussion (Misc queries) | |||
Search/Match between 2 x separate Worksheets and populate result in third worksheet | Excel Discussion (Misc queries) | |||
Weekly Transaction Processing | Excel Worksheet Functions | |||
copyright and worksheet protection | Excel Discussion (Misc queries) |