title: Prevent @ signs in formulas
body: <p>I was playing around with Excel to try and help out a friend with a problem, and wrote the following macro</p>
  
  <pre><code>Sub test()
  
  Worksheets("Sheet3").Cells(1, 4) = "=SUM(A1:A2)"
  
  End Sub
  </code></pre>
  
  <p>The idea was to try and figure out if I could create a macro that writes formulas in a specific cell (which we know we could) but also be able to change the range of the formula.</p>
  
  <p>For example, if instead of just 2 values to sum up, I had 4 values, we want the macro to the able to count all the values and then set a range for all the formulas.</p>
  
  <p>The problem here is that when I write the piece of code shown above, for some reason in the cell it appears " <code>=@SUM(A1:A2)</code> ". I have no idea what the "@" symbol  is supposed to do nor why it is showing up. As a result though, I get a "name?" error and the function doesn't work. However, if I manually delete the "@" symbol, it works perfectly.</p>
  
  <p>Can anyone explain why the "@" symbol is showing up and how not make it show up ?</p>