data validation list selected from a range
It doesn't use a list. It uses a custom formula.
Native wrote:
Dave: tried your formula but keep getting the same message:
"The List Source must be a delimited list, or a reference to a single
row or column."
Also, I can't type in all the values b/c the list is ever changing
hence I have an array name that references a range.
--
Dave Peterson
|