title: Copy a formula from one cell, paste formula in another cell, calculate and paste special values over the formula
body: <p>I have a formula in cell <code>c15</code> that I need to copy down the entire column. However, I want to copy the formula down one cell at a time, calculate the value and then paste special values over that cell. </p>
  
  <p>I want to repeat the code below to calculate one cell at a time. I can't repeat until the last cell is empty because they are all empty except cell <code>c15</code> so I'm not sure how to stop the loop. </p>
  
  <pre><code>Sub Macro5()
      Range("c16:c3000").Formula = Range("c15").Formula
      Range("c16:c250").Calculate
      Range("c16:c250").Value = Range("c16:c250").Value
  End Sub`
  </code></pre>