How to AVERAGE using arrays in VBA (No cell references)

Hi forum,

I'd like to calculate an average of the last n values in an array. I plan on creating a loop for n but to keep things simple, let's just say n = 10.

I would like to calculate an average of the last 10 values in a list. I have written the column to an array and i'd like to use that within VBA, using cell references will take a VERY long time with how many values i'll need to create, especially with a loop for n.

I can not get my head around how I would achieve this so any help is greatly appreciated.

I have created and attached a workbook which shows what i'm trying to do.

Kind regards,
PercivalP.