CODEWITHSUNDEEP
vbaexcelformula
Daniel
Daniel

Reputation: 7038

VBA to fill formula down until last row in empty column

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).

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?

Upvotes: 0

Views: 24358

Answers (1)

A.S.H
A.S.H

Reputation: 29332

let C2 Autofill the column C until the last populated cell in column B:

With Sheets("Report")
  .Range("C2").AutoFill .Range("C2:C" & .Cells(.Rows.count, "B").End(xlUp).row)
End With

Upvotes: 3

Related Questions