title: Force a named range to refer to a literal string
body: <p>I'm using the following VBA code to reproduce the problem:</p>
  
  <pre><code>ActiveWorkbook.Names.Add "Test", RefersTo:="1-2"
  </code></pre>
  
  <p>The resulting named range refers to "=42767" instead of ="1-2"</p>
  
  <p><a href="https://i.stack.imgur.com/KYPva.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/KYPva.png" alt="enter image description here"></a></p>
  
  <p>It seems that it is doing some calculation and setting RefersTo to the result.
  How can I force the range to refer to the literal string "1-2"</p>
  
  <p>Another example (although not as troublesome) </p>
  
  <pre><code>ActiveWorkbook.Names.Add "Test", RefersTo:="123"
  </code></pre>
  
  <p>Results in <code>RefersTo=123</code> instead of the desired <code>RefersTo="123"</code> (number vs text)</p>
  
  <p>Entering the RefersTo through the GUI with quotes works fine but doing it through VBA it gets altered</p>