Thread: make a named range with an array not using a workseet cell range
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions,microsoft.public.excel.misc
John S.[_5_] John S.[_5_] is offline
external usenet poster
  
Posts: 12
Default make a named range with an array not using a workseet cell range

I know I can just make a list in a worksheet and name it but I would like to know if there is a way to just manually
input an array into the named range. I tried this but it does not work. I see that the Refers to is correct but the values
is not set. Ultimately this will be used for a dropdown list. Thanks for any help.


Dim MyWeek

MyWeek = Array("","Mon", "Tue", "Wed", "Thu", "Fri", "Sat", "Sun")

Names.Add Name:="Typelist", RefersTo:=MyWeek
Reply With QuoteReply With Quote