title: Show formula of a cell, but values instead of references
body: <p>I am using a formula to show a cells formula in another cell. </p>
  
  <p>I want to show the values of each reference in this formula, instead of the reference. </p>
  
  <blockquote>
    <blockquote>
      <p>Ex: </p>
    </blockquote>
    
    <p>=$R$16+R19*($T$15-$R$16)</p>
    
    <blockquote>
      <p>Want it to be</p>
      
      <p>=3+2*(4-2)</p>
    </blockquote>
  </blockquote>
  
  <p>Function I am using now to show formula as it is</p>
  
  <pre><code>Function GetFormula(Cell As Range) As String
     GetFormula = Cell.Formula
  End Function
  </code></pre>