I have created a macro with a few autofills.

Looks like this:

ActiveCell.FormulaR1C1 = "=SUM(RC[-1]*0.2)"
Range("C2").Select
Selection.AutoFill Destination:=Range("C2:C18420")
Range("C2:C4329").Select

I will use this macro on a daily basis & the problem is the # of rows changes from day to day. What do I need to change to 'get' the last row & use that row number in the above example?

So if the last row was 19000, my range would be C2:19000.

Thanks in advance for your help!