| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to select a sheet by name
Hi guys,
How can I go to a sheet by name, for example I have a=0 (a is a string, not integer) and a sheet named 0. How can I select the sheet using variable a? Thanks for the help! J. Zhao |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
how to select a sheet by name
Worksheets("0").Activate
-- Gary wrote in message ups.com... Hi guys, How can I go to a sheet by name, for example I have a=0 (a is a string, not integer) and a sheet named 0. How can I select the sheet using variable a? Thanks for the help! J. Zhao |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
how to select a sheet by name
Not sure exactly what you're doing, but this will work as well as what
Gary wrote: a = "0" Worksheets(a).Activate The quotes around the 0 are important! Gary Keramidas wrote: Worksheets("0").Activate -- Gary wrote in message ups.com... Hi guys, How can I go to a sheet by name, for example I have a=0 (a is a string, not integer) and a sheet named 0. How can I select the sheet using variable a? Thanks for the help! J. Zhao |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
how to select a sheet by name
Worksheets(a).Activate
-- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) wrote in message ups.com... Hi guys, How can I go to a sheet by name, for example I have a=0 (a is a string, not integer) and a sheet named 0. How can I select the sheet using variable a? Thanks for the help! J. Zhao |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Alternate Row Select in Sheet 1 then Paste to Sheet 2 | Excel Worksheet Functions | |||
| How do I select price from sheet.b where sheet.a part no = sheet.b | Excel Worksheet Functions | |||
| Use of Sheet CodeNames to Select Sheet in Different Workbook | Excel Programming | |||
| Macro, select Sheet "Number", NOT Sheet Name | Excel Worksheet Functions | |||
| Select Sheet then Select Range | Excel Programming | |||
Linear Mode
