Data Validation Ammendment

I have set up two drop down menus which use data validation. The results of
the second drop down menu depend on what was selected in the first drop down
menu.

Nonetheless, now I want to ammend one of my list. I have tried adding my new
determining factor in the next cell and then highlighting all the cells and
naming the cells again, however whenever I press "return", it just
highlights the original cells, unhighlighting the new one.

Any help?

Do insertnamedefine, select the name and in the refers to box change the
range and click add or select the new range,
insertnamedefine, type the name and click add

--


No private emails please, for everyone's
benefit keep the discussion in the newsgroup.

Regards,

Peo Sjoblom

"Continental Translations" wrote in message
...
I have set up two drop down menus which use data validation. The results
of
the second drop down menu depend on what was selected in the first drop
down
menu.

Nonetheless, now I want to ammend one of my list. I have tried adding my
new
determining factor in the next cell and then highlighting all the cells
and
naming the cells again, however whenever I press "return", it just
highlights the original cells, unhighlighting the new one.

Any help?

Simple as that!

Thanks a lot!

Peo Sjoblom wrote in message
...
Do insertnamedefine, select the name and in the refers to box change the
range and click add or select the new range,
insertnamedefine, type the name and click add

--


No private emails please, for everyone's
benefit keep the discussion in the newsgroup.

Regards,

Peo Sjoblom

"Continental Translations" wrote in
message
...
I have set up two drop down menus which use data validation. The results
of
the second drop down menu depend on what was selected in the first drop
down
menu.

Nonetheless, now I want to ammend one of my list. I have tried adding my
new
determining factor in the next cell and then highlighting all the cells
and
naming the cells again, however whenever I press "return", it just
highlights the original cells, unhighlighting the new one.

Any help?

Hi
see: http://www.contextures.com/xlDataVal02.html

--
Regards
Frank Kabel
Frankfurt, Germany


Continental Translations wrote:
I have set up two drop down menus which use data validation. The
results of the second drop down menu depend on what was selected in
the first drop down menu.

Nonetheless, now I want to ammend one of my list. I have tried adding
my new determining factor in the next cell and then highlighting all
the cells and naming the cells again, however whenever I press
"return", it just highlights the original cells, unhighlighting the
new one.

Any help?