| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using CodeName when Selecting Multi-Tabs
I am hoping that someone is experienced in using the Sheet CodeNames when
selecting Multiple Sheets. I know that you can use Sheet5.Select to go to sheet 5, even though the sheet may have been renamed by the user, sheet 5 remains constant in Properties. I can select multiple sheets, using Sheets(Array("MySheet", "YourSheet", "ThereSheet")).Select. But, I want to be able to use the CodeName instead, I'm unable to find any references to doing so. By using the CodeName, I wouldn't have to track the changes in the user applied sheet names. Can anyone help me on this? I appreciate it. Dean |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Simple ? countif, 3 separate conditions across multi tabs | Excel Worksheet Functions | |||
| Can Pivot tabel be linked to multi-tabs? | Excel Discussion (Misc queries) | |||
| Selecting a subset of data from multi columns | Excel Discussion (Misc queries) | |||
| Selecting a sheet by codename | Excel Programming | |||
| Multi Check Boxes (Selecting Just One) | Excel Programming | |||
Threaded Mode
