Retrieving stored names of drop down lists

M

MZ

How can I retreive existing names of a drop down lists that I have created.
The validation box requires you to type an equal sign followed by the name.
What do you do if you forget the name?
 
R

Rich/rerat

MZ,
If the range name is located in the workbook, you should find it under:
Insert> Name> Define> Known Lists in Workbook will show.

If the range name is in another workbook, then you will need to search
through them to fine its location.

--
Add MS to your News Reader: news://msnews.microsoft.com
Rich/rerat
(RRR News) <message rule>
<<Previous Text Snipped to Save Bandwidth When Appropriate>>


How can I retreive existing names of a drop down lists that I have created.
The validation box requires you to type an equal sign followed by the name.
What do you do if you forget the name?
 

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

Drop down lists 8
Nesting drop down lists? (Excel 2007) 9
Drop down list quicker selection 5
data validation list 17
Hiding information 4
drop down lists 1
problem with drop down lists 1
Drop Down Lists 2007 10

Top