| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions,microsoft.public.excel.misc
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| make a named range with an array not using a workseet cell range | Excel Programming | |||
| Selecting a named range, the name of the named range is in a cell | Excel Programming | |||
| Named range in workseet code | Excel Programming | |||
| Array as a "named range" - formula ok in cells, but error as "named range" | Excel Discussion (Misc queries) | |||
| If any cell in named range = 8 then shade named range | Excel Programming | |||
![John S.[_5_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
