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.

Brilliant! Thank you both. I have taken what you have typed, incorporated it into my main system and it's working. I've not run the whole thing yet but this should be SO much quicker now. Thank you both again.