I think I've managed to isolate the problem with the error. It's the
incremental variable in the Average formula that cannot be recognized.
for example, I can't use rngCol[i] to change the rngCol2 to rngCol3 for
each loop for formula array, gives me an error. Any pointers please?