How to set up a variable range of rows for calculations in VBscript

[Spennyd76]

Hi all. I'm a long time lurker but first time poster. Thanks for all the great content on this site!

I generate a report multiple times a day with varying data which is always formatted the same with exception to the number of "Results". I've created a macro to automatically resize columns, add columns, format, etc...but I'm stumped at how to perform a simple calculation of "Average", "Median", "Max", and "Min" on a range of values due to the fact that sometimes the range is performed on 10 rows, sometimes 8, sometimes 20, etc. I have highlighted the cells in the attached workbook with these simple calculations. I just need help identifying the code that will be flexible to allow for a varying number of Results every time I bring a report into my workbook. Thank you!!!