--
deek
I am trying to use this tip and am running into problems. When I list into
the schedule = EmployeeList I get #NAME? not # VALUE! error. Do you have any
suggestions where I am going wrong?


"Gord Dibben" wrote:

See Debra Dalgleish's site for instructions.

http://www.contextures.on.ca/xlDataVal05.html

Note: the workbook must be open to use the range in another workbook.


Gord Dibben MS Excel MVP

On Thu, 10 Jul 2008 05:16:00 -0700, Don wrote:

morning friends

Is there a way to use the Data/Validation List to use a named range in
another workbook? I want to maintain the list in one place yet have mult
workbooks utilize this so when I have to update the list of dropdowns , I can
do it in one place.

thanks