Thread: Data validation: concatenate two separate ranges in the List?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
DaveO[_2_] DaveO[_2_] is offline
external usenet poster
  
Posts: 46
Default Data validation: concatenate two separate ranges in the List?
In setting up data validation to allow a cell entry from a specified
list, you can define a named range to represent the list and enter the
reference =NamedRange. Is it possible to concatenate two distinct
ranges into a single list?

Reply With QuoteReply With Quote