Do not specify worksheet in a named range

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
You should be able to refer it the same way you do function arguements

=sheet1!NamedRange+sheet3!NamedRange

God Bless

Frank Pytel
 
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.
 
I am sorry. You could certainly refer to the individual cells / cell range
(a1:b5000)

God Bless

Frank Pytel
 
Back
Top