Named Ranges

[davey]

On the menu I go to Insert > Name > Define, and then the box pops u
with a list of all my named ranges.

I notice that in the "main list area" that some of the range names hav
another name in the column to the right. I am going to try to attach
picture of what I'm talking about that shows a cluster of range name
that have the word "estimate" in the column to the right, yet other
don't have any name in the column to the right.

What does it mean when there is or isn't a name to the right of th
Range Name?

Thanks!

Dave

+-------------------------------------------------------------------
|Filename: Names.jpg
|Download: http://www.excelforum.com/attachment.php?postid=3552
+-------------------------------------------------------------------

 

[Bob Phillips]

Is estimate the name of a worksheet, and the worksheet that you are on?

This refers to the fact that the name is a local name, local to just that
worksheet, it cannot be used as easily on other worksheets.

A detailed explanation can be found at
http://www.xldynamic.com/source/xld.Names.html

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Ron Coderre]

Named ranges exist at either the Workbook level or the Worksheet level.


For instance, you could have a range named "myWorkbookRange" which
when viewed in the Define Name window, will not display text to th
right of the range name. You can access those names from anywhere i
the workbook by using Edit>Goto or the Name Box (at the upper left o
the workbook).

Alternatively, you could create a Sheet level range name by prependin
the name of the worksheet to the range name:
Insert>Name>Define
Name: Sheet2!mySheetRange
Refers to: =Sheet2!$A$1:$D$10

As soon as you click the [Add] button, you'll see the sheet referenc
displayed to the right of the range name. Also, that name will only b
visible in the Go To window and the Name Box when Sheet2 is selected.

Does that help?

Regards,
Ro

 

[davey]

Ron and Bob,

Thanks for your help. I understand now. Yes, "estimate" is a
worksheet.

Now, is there any quick and simple way to change my "local" ranges to
"global" ranges? I don't recall ever setting them up as "local" but I
am thinking this happened when I merged parts of 2 workbooks together.

So, as I asked above, is there any simple way to make them global?

Even if not simple, is there a way to do it without starting from
scratch?

Thanks!

- Davey

 

[Bob Phillips]

Davey,

What you will probably find is that you have local and global versions of
the same name (it happens <g>).

To check, go to a worksheet where you know there is a local name and
double-check it is there local. Then go to another sheet, and check it. You
will probably see it there, but without the sheet name. SO go back to the
first sheet and delete it. Does it still exist, but without the sheet name?

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Dave Peterson]

If you work with names, do yourself a favor and get a copy of Jan Karel
Pieterse's (with Charles Williams and Matthew Henson) Name Manager:

You can find it at:
NameManager.Zip from http://www.oaltd.co.uk/mvp