| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Do not specify worksheet in a named range
I have defined range names that I want to use in more than one worsheet in
the same workbook, to refer to cells in the same worksheet. However, Excel always inserts the present-worksheet name in any name definition. Is there any way to supress this, so that I can use names in the way I've indicated? Thanks. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sumproduct against worksheet vs named range- any speed difference? | Excel Worksheet Functions | |||
| Getting a named range to appear in another worksheet | Excel Discussion (Misc queries) | |||
| Removing `named range´ from worksheet | Excel Discussion (Misc queries) | |||
| Using Named Range with protection on the worksheet | Excel Discussion (Misc queries) | |||
| toggling which worksheet a named range refers to | Excel Discussion (Misc queries) | |||
Threaded Mode
