title: If statement with a loop - large data set
body: <p>Currently I am using the following code to add a formula to cells in the column for a predefined range of cells. The problem is that the number of cells I need the formula in fluctuates based on how big the data set is.</p>
  
  <pre><code>Range("R9").Select
  ActiveCell.FormulaR1C1 = "=IF(RC[-1]&lt;0,""False"",""True"")"
  Selection.AutoFill Destination:=Range("R9:R12000")
  Range("R9:R62053").Select
  </code></pre>
  
  <p>What I want to do is for every cell that has a value in say column B, I want the macro to insert the formula in the corresponding cell in column C, and stop once it reaches a point where the cell in column b has no value.</p>