title: range.formula = ... Excel inserts a "@" and breaks how I want the formula to act
body: <p>I am trying to code a vba action that results in a Spilling formula.</p>
  <pre><code>ActiveSheet.Range(&quot;B1&quot;).Formula = &quot;=NUMBERVALUE(&quot; &amp; topStore.Worksheet.Name &amp; &quot;!&quot; &amp; topStore.Address &amp; &quot;:&quot; &amp; botStore.Address &amp; &quot;)&quot;
  </code></pre>
  <p>As a string variable, the value is</p>
  <pre><code>=NUMBERVALUE(Shipping!$A$2:$A$3592)
  </code></pre>
  <p>But when it lands in B1 it always has a @ in it and it results in a #VALUE! error.</p>
  <pre><code>=NUMBERVALUE(@Shipping!$A$2:$A$3592)
  </code></pre>
  <p>Is there a setting that I can disable or something I can add to the command that would prevent the @?</p>