title: using cell address in vba formula
body: <p>I'm trying to use cell address in IF formula and I get an ERROR msg.
  I defined a AvgCell/StdCell as string, and my IF function doesn't how to read it</p>
  
  <p>Here is the code:</p>
  
  <pre><code>Dim AvgCell As String  
  ActiveCell.Formula = "=AVERAGE(M" &amp; StartRow &amp; ":M" &amp; myRow - 1 &amp; ")"     
  AvgCell = Cells(myRow + 1, 14).Address     
  Cells(k, 14).FormulaR1C1 = "=IF(RC[-1]&gt;" &amp; AvgCell &amp; " + " &amp; StdCell &amp; ",1,0)"
  </code></pre>