Data validation using hard-typed Named Range

[hyperchondriac]

I'm trying to create a drop-down list of months in a cell. I wanted to use Data Validation to refer to a named range where I would type the list of months. However, I can't get the format right.

In the attached image, the "MyList" name (referring to a range of cells) will work but when I try to copy the format of the Value in the "Months" name, it doesn't work. What am I missing?

 

[RoryA]

A data validation list source has to be either an actual range (not an array) or a literal comma delimited list.

 

[hyperchondriac]

Okay thanks, so there is no option to put a literal comma delimited list into a named range and then reference that named range in the data validation?

 

[RoryA]

Afraid not.

 

[hyperchondriac]

Ah, well that's annoying but thanks for clarifying.