title: Excel Escaping Single and double quotes
body: <p>I have a formula in each cell in excel where I need to edit.  But I am having a hard time escaping the single quotes and double quotes using VBA code.</p>
  
  <p>This is an example:</p>
  
  <pre><code>=+'F-222Alloc'!N2516+'F-222Alloc'!N2526
  </code></pre>
  
  <p>I need it to look like this</p>
  
  <pre><code>=+INDIRECT("'"&amp;N14&amp;"'!N2511")+INDIRECT("'"&amp;N14&amp;"'!N2526")
  </code></pre>
  
  <p>How do I use the REPLACE function properly?</p>