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.

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.

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.

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.