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 |
All times are GMT +1. The time now is 12:12 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com