Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Select sheet based on reference
Hi,
I'm able to selecet a workbook, but not a sheet based on a reference like so: Sub test() Dim AString AString = Sheets("Input").Range("A1").Value Windows(AString).Activate = works Sheets(AString).Select = doesn't work End Sub Can someone think of a (alternative) way it will work? Thanks in advance, Hans Weustink |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using VBA select sll sheets based on Criteria on each sheet. | Excel Discussion (Misc queries) | |||
Copy rows to new sheet based cell reference, not value | Excel Discussion (Misc queries) | |||
How do I select price from sheet.b where sheet.a part no = sheet.b | Excel Worksheet Functions | |||
Select Sheet then Select Range | Excel Programming | |||
Select sheet based on cell value | Excel Programming |