(Solved) – Rows to be Dynamic [closed]

  • by
(solved)-–-rows-to-be-dynamic-[closed]

I am trying to calculate some time formats to get averages of columns. The different files I will be using these calculations on have varying row counts. So I am trying to adjust the below code to adjust to the last row of data, rather than a specific cell. These 2 are separate codes that I am looking to change or adjust to account for the dynamic row number.

Rows("2:1048575").Select     

ActiveCell.FormulaR1C1 = "=AVERAGE(R[-1048574]C:R[-1]C)"

Leave a Reply

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