title: Retrieve Named Cell's Refers to Cell, not resultant value
body: <p>I have a Named Cell called &quot;StandardSQFT&quot; that is dynamic in the fact that it changes on particular sheet's Activate. For example:</p>
  <pre><code>Private Sub Worksheet_Activate()
  ActiveWorkbook.Names(&quot;StandardSQFT&quot;).RefersTo = &quot;='Fuel Tank'!$C$40&quot;
  End Sub
  </code></pre>
  <p>No, I have another sheet that I want to now what cell/sheet &quot;StandardSQFT&quot; refers to , not the value.
  I'd like to enter in a cell:</p>
  <p><code>=StandardSQFT.RefersTo</code> and see the result of: <code>='Fuel Tank'!$C$40</code></p>
  <p>Is this possible? The above doesn't work, nor does StandardSQFT.LinkedCell.</p>
  <p>I'm sure this is simple so please go ahead and laugh at what I am missing here ...</p>