Data Validation between open Workbooks
 

I have a several lists in WorkbookA that is has a name range assign to each
list. WorkbookB is the workbook where the data validation is applied.
WorkbookA
is kept opened as well.

But I get one of two errors when tring to apply data validation:
1. The Source currently evaluates to an error.
2. A Named range you specified can not be found.

Can anybody give me some insite as to why I'm getting these two type of
errors.

Steve

Data Validation between open Workbooks
 

In the destination workbook, create a name that refers to the list in
the source workbook. There are instructions he

http://www.contextures.com/xlDataVal05.html

caldog wrote:
I have a several lists in WorkbookA that is has a name range assign to each
list. WorkbookB is the workbook where the data validation is applied.
WorkbookA
is kept opened as well.

But I get one of two errors when tring to apply data validation:
1. The Source currently evaluates to an error.
2. A Named range you specified can not be found.

Can anybody give me some insite as to why I'm getting these two type of
errors.

Steve




--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html