Having number of rows known you can try this
You have final row number "r", you can use for loop to fill  the formula in
range
like

for each cell in range  ("C1: C"&r)
c = "your formula" here.
activecell.offset(1,0).select
next