title: Inserting value into Excel cell instead of formula
body: <p>I have a VBA script that inserts long strings into Excel cells. In some cases, the string begins with a <code>=</code>. It seems like Excel interprets this as a formula and I get an <code>Out of Memory</code> error due to the memory limitations of formulas.</p>
  
  <p>How do I tell Excel that I am writing a value, not a formula? Currently, I am doing this:</p>
  
  <pre><code>ws.Range("A" &amp; row) = Mid(xml, first, CHUNK_SIZE)
  </code></pre>
  
  <p>I have tried the following code, but it doesn't work...</p>
  
  <pre><code>ws.Range(...).Value = ....
  </code></pre>