Try putting in just =NamedRange for the Source under Allow: List. Below is the
range I have for NamedRange and all the cells that require this validation on any
worksheet find it. If I'm not understanding your question properly, my apologies
and I hope someone more experienced can offer another suggestion.
NamedRange:
=Sheet1!$G$28:$G$37
G28 List Item #1
G29 List Item #2
G30 List Item #3
G31 List Item #4
G32 List Item #5
G33 List Item #6
G34 List Item #7
G35 List Item #8
G36 List Item #9
G37 List Item #10
"taych " wrote in message
...
Sorry Andy, try it out but does not work.
---
Message posted from http://www.ExcelForum.com/