I am receiving an error on the line below:
Arr() is an array variable, N is an integer, Arr() is currently (1 to 2978, 1 to 9)
How can I use the average function to find the average of the values in the 8th column? Or is there another way I can find the average of a set of values in an array?
Thanks!
Code:
M = Application.Average(Arr(2, 8), Arr(N, 8))
Arr() is an array variable, N is an integer, Arr() is currently (1 to 2978, 1 to 9)
How can I use the average function to find the average of the values in the 8th column? Or is there another way I can find the average of a set of values in an array?
Thanks!