View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Matt Brown[_2_] Matt Brown[_2_] is offline
external usenet poster
 
Posts: 1
Default How to select named range list dependent on another selection

I want to offer a named range list based on a selection from another list.
ie
if
a1 selection from named range "typesofpet" is "dog" then a2 named range list
= listofdogs
elseif
selection from named range "typesofpets" = to "cat" then a2 named range is =
"listofcats"