Data Validation between open Workbooks

C

caldog

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
 

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

retrieve data from different workbook 1
Data Validation - using a list from another workbook 4
custom menu cross contamination between open workbooks. 2
VBA Stmt Format to Get Contents of Cell in Another Book 1
On Errror Goto Error handler only works first time through "For Each" cycle 2
Data Validation -> Validation list is larger than the cell width 1
VBA for data validation in 3rd column does not run. I need help. 1
Code execution is correct but generates Error :The file you aretrying to open is in a different form 3

Top