Is it possible to have the name in the 'Named Box' be linked to a specific
cell so the name of that list changes if you change the name of that cell?

Hi,

Give use more detail about your specific needs. Forget the Name Box, that
is just where you see the name of a range or enter a new name. It may be
that you want to look at the INDIRECT function, but I'm not clear enough
about what you want to say more.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Joey Spreadsheets" wrote:

Is it possible to have the name in the 'Named Box' be linked to a specific
cell so the name of that list changes if you change the name of that cell?

Not sure what you want... Pl. provide more details with examples...

Default names of cells are like A1, B1 etc...

"Joey Spreadsheets" wrote:

Is it possible to have the name in the 'Named Box' be linked to a specific
cell so the name of that list changes if you change the name of that cell?

That namebox will show a name for the selection. So you'd have to change the
selection each time you updated that cell.

Is that what you'd want?

If you're working with names and struggling to see what each name refers to, do
yourself a big 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


Joey Spreadsheets wrote:

Is it possible to have the name in the 'Named Box' be linked to a specific
cell so the name of that list changes if you change the name of that cell?

--

Dave Peterson

hi
not sure but IF i understand you, the answer in no.
named ranges are aliases you assign your ranges. a range or cell can have
more than 1 name. (not sure if there is a limit.) named ranges can overlap.
if you want to change the name of one of your named ranges, you have to
delete the old name and add the new. you can add new names in the name box
but to delete you have to do that in the add names dialog.
2003 on the menu barinsertnamedefine.
not sure were it is in 07.

post back if i misunderstood.
Regards
FSt1


"Joey Spreadsheets" wrote:

Is it possible to have the name in the 'Named Box' be linked to a specific
cell so the name of that list changes if you change the name of that cell?

I am looking for a easy way to create the Named Boxes, without having to type
them in, but rather reference a specific cell that would contain the name. I
have about 200 different rows that I want to define the names for their
ranges so I can use them with a dropdown via Validation (a question I posted
& got an answer to yesterday). Do I have to define each of the 200 ranges
individually by typing in their names or is there a simpler way?

Example of the data: Column A contains the name of the range I would like
to use. Columns B thru M have the items I want to have included in the list.
There are 200 rows going down with different items going across the columns.



hi
not sure but IF i understand you, the answer in no.
named ranges are aliases you assign your ranges. a range or cell can have
more than 1 name. (not sure if there is a limit.) named ranges can overlap.
if you want to change the name of one of your named ranges, you have to
delete the old name and add the new. you can add new names in the name box
but to delete you have to do that in the add names dialog.
2003 on the menu barinsertnamedefine.
not sure were it is in 07.

post back if i misunderstood.
Regards
FSt1


"Joey Spreadsheets" wrote:

Is it possible to have the name in the 'Named Box' be linked to a specific
cell so the name of that list changes if you change the name of that cell?

Maybe...

Put the names in row 1 of each column.
Select the range (all the columns)

In xl2003 menus:
Insert|name|create|check create names in top row

(Make sure the values in row 1 are valid names.)

Joey Spreadsheets wrote:

I am looking for a easy way to create the Named Boxes, without having to type
them in, but rather reference a specific cell that would contain the name. I
have about 200 different rows that I want to define the names for their
ranges so I can use them with a dropdown via Validation (a question I posted
& got an answer to yesterday). Do I have to define each of the 200 ranges
individually by typing in their names or is there a simpler way?

Example of the data: Column A contains the name of the range I would like
to use. Columns B thru M have the items I want to have included in the list.
There are 200 rows going down with different items going across the columns.


hi
not sure but IF i understand you, the answer in no.
named ranges are aliases you assign your ranges. a range or cell can have
more than 1 name. (not sure if there is a limit.) named ranges can overlap.
if you want to change the name of one of your named ranges, you have to
delete the old name and add the new. you can add new names in the name box
but to delete you have to do that in the add names dialog.
2003 on the menu barinsertnamedefine.
not sure were it is in 07.

post back if i misunderstood.
Regards
FSt1


"Joey Spreadsheets" wrote:

Is it possible to have the name in the 'Named Box' be linked to a specific
cell so the name of that list changes if you change the name of that cell?

--

Dave Peterson

SWEET! It worked! Thank you so much. This will save me a lot of time!

"Dave Peterson" wrote:

Maybe...

Put the names in row 1 of each column.
Select the range (all the columns)

In xl2003 menus:
Insert|name|create|check create names in top row

(Make sure the values in row 1 are valid names.)

Joey Spreadsheets wrote:

I am looking for a easy way to create the Named Boxes, without having to type
them in, but rather reference a specific cell that would contain the name. I
have about 200 different rows that I want to define the names for their
ranges so I can use them with a dropdown via Validation (a question I posted
& got an answer to yesterday). Do I have to define each of the 200 ranges
individually by typing in their names or is there a simpler way?

Example of the data: Column A contains the name of the range I would like
to use. Columns B thru M have the items I want to have included in the list.
There are 200 rows going down with different items going across the columns.


hi
not sure but IF i understand you, the answer in no.
named ranges are aliases you assign your ranges. a range or cell can have
more than 1 name. (not sure if there is a limit.) named ranges can overlap.
if you want to change the name of one of your named ranges, you have to
delete the old name and add the new. you can add new names in the name box
but to delete you have to do that in the add names dialog.
2003 on the menu barinsertnamedefine.
not sure were it is in 07.

post back if i misunderstood.
Regards
FSt1


"Joey Spreadsheets" wrote:

Is it possible to have the name in the 'Named Box' be linked to a specific
cell so the name of that list changes if you change the name of that cell?

--

Dave Peterson

It may have worked for you, but I wonder if it's really the best way to go.

But I don't think you've shared enough to get any other suggestions (well, if
you wanted some).

Joey Spreadsheets wrote:

SWEET! It worked! Thank you so much. This will save me a lot of time!

"Dave Peterson" wrote:

Maybe...

Put the names in row 1 of each column.
Select the range (all the columns)

In xl2003 menus:
Insert|name|create|check create names in top row

(Make sure the values in row 1 are valid names.)

Joey Spreadsheets wrote:

I am looking for a easy way to create the Named Boxes, without having to type
them in, but rather reference a specific cell that would contain the name. I
have about 200 different rows that I want to define the names for their
ranges so I can use them with a dropdown via Validation (a question I posted
& got an answer to yesterday). Do I have to define each of the 200 ranges
individually by typing in their names or is there a simpler way?

Example of the data: Column A contains the name of the range I would like
to use. Columns B thru M have the items I want to have included in the list.
There are 200 rows going down with different items going across the columns.


hi
not sure but IF i understand you, the answer in no.
named ranges are aliases you assign your ranges. a range or cell can have
more than 1 name. (not sure if there is a limit.) named ranges can overlap.
if you want to change the name of one of your named ranges, you have to
delete the old name and add the new. you can add new names in the name box
but to delete you have to do that in the add names dialog.
2003 on the menu barinsertnamedefine.
not sure were it is in 07.

post back if i misunderstood.
Regards
FSt1


"Joey Spreadsheets" wrote:

Is it possible to have the name in the 'Named Box' be linked to a specific
cell so the name of that list changes if you change the name of that cell?

--

Dave Peterson


--

Dave Peterson