| 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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Do not specify worksheet in a named range
You should be able to refer it the same way you do function arguements
=sheet1!NamedRange+sheet3!NamedRange God Bless Frank Pytel "hmm" wrote: 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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Do not specify worksheet in a named range
Thanks, Frank. I tried your suggestion; unfortunately, if the name is
defined while the active cell is in Sheet 1, it will refer to Sheet 1, even where entering =Sheet3!NAME. "Frank Pytel" wrote: You should be able to refer it the same way you do function arguements =sheet1!NamedRange+sheet3!NamedRange God Bless Frank Pytel "hmm" wrote: 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. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Do not specify worksheet in a named range
I am sorry. You could certainly refer to the individual cells / cell range
(a1:b5000) God Bless Frank Pytel "hmm" wrote: Thanks, Frank. I tried your suggestion; unfortunately, if the name is defined while the active cell is in Sheet 1, it will refer to Sheet 1, even where entering =Sheet3!NAME. "Frank Pytel" wrote: You should be able to refer it the same way you do function arguements =sheet1!NamedRange+sheet3!NamedRange God Bless Frank Pytel "hmm" wrote: 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. |
| Reply |
| 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) | |||
Hybrid Mode
