User to provide input for row to use

[jlax34]

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:

Please Login or Register  to view this content.

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.

[jaslake]

Hi jlax34

Here's two ways to do this

Please Login or Register  to view this content.

and

Please Login or Register  to view this content.