Thread
:
Convert Worksheet List to Named Array Constant
View Single Post
#
4
Posted to microsoft.public.excel.programming
Don Guillett
external usenet poster
Posts: 10,124
Convert Worksheet List to Named Array Constant
???
range("a1:a12").name="Months"
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
"Steph" wrote in message
...
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
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett