I have a macro that updates the formulas for a sheet once subtotals are put in. The way I have it written now, it is hard coded to go to a certain line. The problem is, if something changes which affects the first line of subtotals, I have to do a quick update on the macro to make it work. I want the user to input the first line for the subtotal and have my formulas reference that line instead. I know it isn't super complicated to figure out, but this isn't something I have messed with too much.

An example of the basic code that is being updated:

    Range("U35").Select
    ActiveCell.FormulaR1C1 = "=RC[9]/RC[-16]"
    Range("Y35").Select
    ActiveCell.FormulaR1C1 = "=RC[-2]/RC[-1]"
    Range("AC35").Select
    ActiveCell.FormulaR1C1 = "=RC[-6]/RC[-24]"
    Range("AE35").Select
    ActiveCell.FormulaR1C1 = "=RC[-7]/RC[-1]"
I would need what I need to put in place of "u35" so that the user input will not it is column U on row "x" as well as the code to create the variable.