title: formulaR1C1 insert concatenate string in excel vba
body: <p>I'm trying to insert a concatenated string into a cell using VBA.  Here's the formula I want to insert:</p>
  
  <pre><code>="ObjectID(" &amp; E152 &amp; ")"
  </code></pre>
  
  <p>here's what I'm trying, but I can't get it to work:</p>
  
  <pre><code>ActiveCell.FormulaR1C1 = "=""ObjectID("" &amp; RC[-1] &amp; ")"
  </code></pre>
  
  <p>I've tried <code>"")"</code> and <code>")""</code> and a bunch of other combinations, but I cant get it to work.</p>
  
  <p>How do I do this?</p>