title: Formula to remain after running macro
body: <p>I was wondering how I can have a formula stay on column J2:J600. The formula is <code>=R2</code> and would go all the way down to <code>=R600</code>. I thought I could manually put the formula in but every time I run my macro, the formulas disappear. Is there a way to embed the formula into the column? Thanks.</p>
  
  <p><strong>EDIT</strong></p>
  
  <pre><code>Sub FormatCounsel()
      Sheet2.Range("J2").FormulaR1C1 = "=RC[0]"`
      Sheet2.Range("J2").AutoFill Destination:=Range("J2:J600"), Type:=xlFillDefault
  End Sub
  </code></pre>
  
  <p>This is what I put in and I'm getting an error.</p>
  
  <p><strong>EDIT 2</strong></p>
  
  <p>Sorry I just realized that I want the formula <code>=R2</code> in cells <code>J2:J600</code>. Sorry if I caused any confusion.</p>