title: Getting around quotes inside Excel VBA
body: <p>I have a Excel Formula that I'm using inside VBA. However, when I'm compiling it, VBA throws me an error. </p>
  
  <p>I'm kind of certain that it is because of the quotes in my Formula. </p>
  
  <pre><code>Range("E2:E" &amp; lastRow).FormulaLocal = "=IFERROR(IF(VLOOKUP(D2,$B:$B,1,FALSE)=D2,"Form Present"),"Not Present")"
  </code></pre>
  
  <p>This is what I tried to get around this, </p>
  
  <pre><code> Range("E2:E" &amp; lastRow).FormulaLocal = "=IFERROR(IF(VLOOKUP(D2,$B:$B,1,FALSE)=D2,&amp;Chr(34)&amp;Form Present&amp;Chr(34)&amp;),&amp;Chr(34)&amp;Not Present&amp;Chr(34)&amp;)"
  </code></pre>
  
  <p>I used chr(34) to generate a Quote symbol within however this is not working. Any workaround for this? </p>