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!
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!