Hi

I am trying to establish data validation in "WorkbookA" from another
workbook "WorkbookB".

The location of WorkbookB may change from time to time, but will always
be located in same path as WorkbookA, but under a different subroot, say
the "data\" subroot. The rangename that holds the data to be validated
is "List_Months" in WorkbookB.

I have created a range in WorkbookA called "MyList" by adding the
following formula to the "refers to" box,
="'"&LEFT(INFO("directory"),FIND("Data\",INFO("dir ectory"))-1)&"WorkbookB"&".xls'!"&"List_Months2"

When I attempt to use the name under the "list" option in Data
Validation I receive the message "the list source must be a delimited
list or a reference to a single row or column."

Thanks in advance for your assistance
Peter


--
PeterW
------------------------------------------------------------------------
PeterW's Profile: http://www.excelforum.com/member.php...fo&userid=6496
View this thread: http://www.excelforum.com/showthread...hreadid=493675