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?
Thanks much!ActiveCell.FormulaR1C1 = "=COUNTIFS(R2C18:R50C18,RC[3],R2C14:R50C14,""<>"" &"""")/SUMIF(R2C18:R50C18,RC[3],R2C7:R50C7)"
Bookmarks