title: VBA to fill formula down until last row in empty column
body: <p>I have a report with a row count that changes daily. I need to autofill column C with a formula down to the last row of column B (columns A and B have different row counts, if that matters).</p>
  
  <p>I have the formula in C2 (and a header in C1), how do I get vba to copy the formula in C2 down to the same row number as column B?</p>