| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Alternate way to refer to sheets???
My VBA code always assumes that the names of my sheets
will never change. However, if a user changes the name of "Sheet1" to something else (such as "mysheet", for example), then my VBA will not be able to find the sheet formerly known as "Sheet1". Is there a solution to this problem?? Is there an alternate way to refer to a sheet other than by the label name on the tab?? thankx |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Hyperlink Alternate Sheets | Excel Discussion (Misc queries) | |||
| find out which sheets refer to a cel | Excel Worksheet Functions | |||
| refer to sequential sheets in a formula | Excel Worksheet Functions | |||
| #REF in Sheets that refer to Pivot Tables | Excel Discussion (Misc queries) | |||
| refer to the sheets Name property in my code (not what is on the Tab) | Excel Programming | |||
Threaded Mode
