Change Static Range of Formula to Dynamic Range

Hello all,

I have this code below that was created by the macro recorder. The only problem I'm having is that I need to run this code again and again and the number of rows will always be different.

How can I change the recorded code below to select the current region of each relevant area and be dynamic instead of static?

ActiveCell.FormulaR1C1 = "=COUNTIFS(R2C18:R50C18,RC[3],R2C14:R50C14,""<>"" &"""")/SUMIF(R2C18:R50C18,RC[3],R2C7:R50C7)"

Thanks much!