View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson
 
Posts: n/a
Default 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