(Solved) – How to make the subtotal formula to the end automatically?

(solved)-–-how-to-make-the-subtotal-formula-to-the-end-automatically?

I am running a macro that I have the different rows every day and in the and I would like to create a subtotal.

as example:

Sheets("RBC_data").Select

Range("R1").Select

Selection.End(xlDown).Select

ActiveCell.Offset(rowoffset:=1).Activate

ActiveCell.FormulaR1C1 = "=SUBTOTAL(9,R.....

How I can write the code for the formula select the row R2 to the end and make the formula subtotal?

Leave a Reply

Your email address will not be published. Required fields are marked *