title: Define a custom named list in Excel to be used for data-validation
body: <p>I am trying to set up a drop-down menu in Excel using a named list, but I would like to write the entries for the named variable myself.</p>
  
  <p>So, say I define a named list (call it TestVar) as (using the Name manager)</p>
  
  <pre><code>={"A","B"}
  </code></pre>
  
  <p>(alternatively with a semi-colon to create a column), I cannot use it for data validation. So if I under data validation choose the "list" option, and write</p>
  
  <pre><code>=TestVar
  </code></pre>
  
  <p>as the source, I get the "The Source currently evaluates to an error." message. </p>
  
  <p>I don't understand why TestVar isnt't a valid list, as it works with both the INDEX-function, as well as array formulas.</p>
  
  <p>Also, I know that I could write </p>
  
  <pre><code>A,B
  </code></pre>
  
  <p>as the source when setting up my data-validation, and that gives me the behaviour I want, but I think it makes more sense to have it defined as a named list, in case one needs to append to the list at some point in the future, and the list is referenced multiple times in the document.</p>
  
  <p>Edit:</p>
  
  <p>Forgot to mention that I use Excel 2013.</p>