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)"