| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
unchanging worksheet reference
Is there a way to refer to a worksheet other than by index or name?
Something that won't change as long as the worksheet exists. Worksheets(1) or Worksheets("some sheet name") will no longer be valid if someone inserts another worksheet before this one, or changes this one's name. I'd like to be able to refer to a particular worksheet even if its name or position in the workbook changes. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Unchanging Cell Color | Excel Discussion (Misc queries) | |||
| Unchanging cell question | Excel Discussion (Misc queries) | |||
| Cell Value & unchanging Date With Macro run | Excel Programming | |||
| I want in one worksheet to relatively link to/reference cells in another without changing the format of the current worksheet. | Excel Discussion (Misc queries) | |||
| Reference to ActiveX control on worksheet requires full worksheet name | Excel Programming | |||
Threaded Mode
