| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel,microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
|
|||
|
|||
accessing worksheets
Hello,
I have a question about referencing a specific sheet. I see you can do this: ThisWorkbook.Worksheets("MySpecialSheet").Select Or ThisWorkbook.Worksheets(2).Select However, if the user changes the name of the sheet to "MySpecialSheet2" or re-order the tabs you cannot use those. I see there is a property CodeName. Which always has the default "Sheet<x" name. Can this be used? Is there some other way to identify the sheet? Thanks |
|
#2
Posted to microsoft.public.excel,microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
accessing worksheets
Yes you can use CodeName
Sheet2.Select -- HTH RP (remove nothere from the email address if mailing direct) "greg" wrote in message ... Hello, I have a question about referencing a specific sheet. I see you can do this: ThisWorkbook.Worksheets("MySpecialSheet").Select Or ThisWorkbook.Worksheets(2).Select However, if the user changes the name of the sheet to "MySpecialSheet2" or re-order the tabs you cannot use those. I see there is a property CodeName. Which always has the default "Sheet<x" name. Can this be used? Is there some other way to identify the sheet? Thanks |
|
#3
Posted to microsoft.public.excel,microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
accessing worksheets
thanks for the help
"Bob Phillips" wrote in message ... Yes you can use CodeName Sheet2.Select -- HTH RP (remove nothere from the email address if mailing direct) "greg" wrote in message ... Hello, I have a question about referencing a specific sheet. I see you can do this: ThisWorkbook.Worksheets("MySpecialSheet").Select Or ThisWorkbook.Worksheets(2).Select However, if the user changes the name of the sheet to "MySpecialSheet2" or re-order the tabs you cannot use those. I see there is a property CodeName. Which always has the default "Sheet<x" name. Can this be used? Is there some other way to identify the sheet? Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| what exactly prevents INDIRECT from accessing closed worksheets? | Excel Worksheet Functions | |||
| accessing worksheets | Excel Worksheet Functions | |||
| Question about accessing worksheets on an AddIn file | Excel Programming | |||
| programatically accessing Macros in worksheets | Excel Programming | |||
| Accessing the values of form controls on worksheets in Excel 2000 | Excel Programming | |||
Linear Mode
