title: Evaluate text containing a named range
body: <p>How do I <strong>evaluate a text string that contains a named range</strong>?
  I tried with EVAL, EVALUATE and INDIRECT with no success.</p>
  
  <p>A bit more..</p>
  
  <p>For another system, I've got 50+ formulas with 200+ variables, an example follows: </p>
  
  <pre><code>&lt;ABC&gt;+&lt;DEF&gt;/&lt;TRE-1&gt;
  </code></pre>
  
  <p>To be able to use them all at once in Excel without manually changing every formula, variable and operator, I use a couple (or more) SUBSTITUTE formulas to render a string that Excel might be able to digest:</p>
  
  <pre><code>=ABC+DEF/TRE_1
  </code></pre>
  
  <p>I referenced all variables to named ranges. For e.g.:</p>
  
  <p>ABC is cell B2, value 5.4</p>
  
  <p>DEF is cell B3, value 3.2</p>
  
  <p>TRE_1 is cell B4, value 1</p>
  
  <p>But then the I can't get the resulting string evaluated with INDIRECT or EVALUATE. 
  It just gives me a #NAME or #REF error, because it seems it doesn't recognize the variable as a named range (and thus a value).</p>
  
  <p>Any ideas?</p>
  
  <p>I don't want to implement this in VBA. I know it's possible using the .RefersTo method..</p>