Need help with dynamic autofill

[oldmanexcel]

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

[scott.s.fower]

Please Login or Register  to view this content.

[scott.s.fower]

p.s. put your code in code tags by selecting your code and hitting the # icon on the quick reply menu bar

[oldmanexcel]

Thanks Scott, it worked perfectly.

I had mistakenly not copied the range ("Z10")

Thanks for the tip on the code tags; I will do that in the future.

I appreciate you assistance