Do not specify worksheet in a named range

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.
 
G

Guest

You should be able to refer it the same way you do function arguements

=sheet1!NamedRange+sheet3!NamedRange

God Bless

Frank Pytel
 
G

Guest

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.
 
G

Guest

I am sorry. You could certainly refer to the individual cells / cell range
(a1:b5000)

God Bless

Frank Pytel
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA - retrieve data on last create named range from previous inserted named range 0
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
worksheet renames - specific 0
shorten worksheet name 1
Use worksheet name in one cell as part of reference in other cells 3
how to make range names universal in workbook 3
Applying Named Ranges to Existing Formulas 3
Hlp! Named range Advanced Filter Criterion 10

Top