Retrieving stored names of drop down lists
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? -- MZ |
Retrieving stored names of drop down lists
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 "MZ" wrote in message ... 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? -- MZ |
All times are GMT +1. The time now is 06:40 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com