I'm very new & inexperienced; I need help with dynamic autofill for 3 formulas, the number of rows in column A data can vary on any given day.

Also, the spredsheet I'm forced to use due to decisions beyond my control begins in A10 not A1.

Can anyone help?

ActiveCell.FormulaR1C1 = "=CONCATENATE(R1C2,RC[-25])"
Range("Z10").AutoFill Destination:=Range("Z10:Z26")
Columns("Z:Z").EntireColumn.Hidden = True
Range("W10").Select
ActiveCell.FormulaR1C1 = _
"=VLOOKUP(RC[3],'[ASW Rate Plan Validation.xlsx]ASW Rates'!C1:C8,7,FALSE)"
Selection.AutoFill Destination:=Range("W10:W26")
Range("X10").Select
ActiveCell.FormulaR1C1 = "=RC[-3]-RC[-1]"
Range("X10").AutoFill Destination:=Range("X10:X26")
Range("X10").Select