You can create a range (i.e. RangeName) that has the validation cells you want,
then choose "List" as the validation criteria. In the range selection, type
=RangeName. You can use the syntax in the same way as referencing other ranges
in workbooks/worksheets. hth
"taych " wrote in message
...
Is there a way to use reference to other worksheets/workbooks for Data
Validation Criteria ?
---
Message posted from http://www.ExcelForum.com/