| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Defining a name that represent identical ranges in every sheet
This is the exact opposite of my previous post about "Defining identical
names that represent different ranges of cells". In order to achieve this just type in an exclamation point before the range definition, such as : Insert/Name/Define Name : Sales Refers to : !A1:A3 The name Sales would then refer to cells A1:A3 local to every sheet. Note that this is quite different from a "3D" reference. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Want cell ref. to change after sort in other sheet | Excel Discussion (Misc queries) | |||
| Returning Values | Excel Discussion (Misc queries) | |||
| Compiling macro based on cell values | Excel Discussion (Misc queries) | |||
| Lookup function and compare | Excel Discussion (Misc queries) | |||
| Naming & renaming a sheet tab | Excel Worksheet Functions | |||
Threaded Mode
