Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have a list on a worksheet. I would like to convert that list to a named
range. Is there a VBA procedure that would do so? For example, in cells A1:A3 I have A1 - Jan A2 - Feb A3 - Mar I would like to convert this list to a defined name called "Months". The defined name dialog box "refers to" input for the name "Months" would look like: ={"Jan","Feb","Mar"} Thanks for your help. -- Steph |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
populate array with list of named range | Excel Programming | |||
Data validation list / named array constant | Excel Worksheet Functions | |||
Named Constant | Excel Programming | |||
Defined named range (Array list) | Excel Programming | |||
Search and replace using a named array on another worksheet | Excel Programming |