Named Ranges
 

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

I notice that in the "main list area" that some of the range names have
another name in the column to the right. I am going to try to attach a
picture of what I'm talking about that shows a cluster of range names
that have the word "estimate" in the column to the right, yet others
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 the
Range Name?

Thanks!

Davey


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

--
davey
------------------------------------------------------------------------
davey's Profile: http://www.excelforum.com/member.php...o&userid=24340
View this thread: http://www.excelforum.com/showthread...hreadid=383680

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)


"davey" wrote in
message ...

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

I notice that in the "main list area" that some of the range names have
another name in the column to the right. I am going to try to attach a
picture of what I'm talking about that shows a cluster of range names
that have the word "estimate" in the column to the right, yet others
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 the
Range Name?

Thanks!

Davey


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

--
davey
------------------------------------------------------------------------
davey's Profile:
http://www.excelforum.com/member.php...o&userid=24340
View this thread: http://www.excelforum.com/showthread...hreadid=383680

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 the
right of the range name. You can access those names from anywhere in
the workbook by using EditGoto or the Name Box (at the upper left of
the workbook).

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

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

Does that help?

Regards,
Ron


--
Ron Coderre
------------------------------------------------------------------------
Ron Coderre's Profile: http://www.excelforum.com/member.php...o&userid=21419
View this thread: http://www.excelforum.com/showthread...hreadid=383680

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


--
davey
------------------------------------------------------------------------
davey's Profile: http://www.excelforum.com/member.php...o&userid=24340
View this thread: http://www.excelforum.com/showthread...hreadid=383680

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)


"davey" wrote in
message ...

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


--
davey
------------------------------------------------------------------------
davey's Profile:
http://www.excelforum.com/member.php...o&userid=24340
View this thread: http://www.excelforum.com/showthread...hreadid=383680

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

davey wrote:

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

I notice that in the "main list area" that some of the range names have
another name in the column to the right. I am going to try to attach a
picture of what I'm talking about that shows a cluster of range names
that have the word "estimate" in the column to the right, yet others
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 the
Range Name?

Thanks!

Davey

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

--
davey
------------------------------------------------------------------------
davey's Profile: http://www.excelforum.com/member.php...o&userid=24340
View this thread: http://www.excelforum.com/showthread...hreadid=383680

--

Dave Peterson