title: problem with VBA apostrophes
body: <p>Single line of code is causing my application to stop working - I think that the problem is with the apostrophes (maybe wrong escape):</p>
  
  <pre><code>.Formula = "=IF(AND(" 'Criterion " &amp; i &amp; "'!" &amp; cellAdress &amp; "&gt;=1;"'Criterion " &amp; i &amp; "'!" &amp; cellAdress &amp; "&lt;=4);"'Criterion " &amp; i &amp; "'!" &amp; cellAdress &amp; ";0)"
  </code></pre>
  
  <p>When I try to enter the "' sequence VBA automatically puts a space between " and ' making the latter appear as comment.  What is wrong - do I need to use escape character here?  If yes how to code it.  I get an error 1004 Application of object-defined error.</p>
  
  <p>Thank you</p>