Average of an array

[Lavina]

Hey guys,

I'm trying to get the average of an array(no empty values) i have. I'm trying to do something like:

averageMonth = Application.WorksheetFunction.Average(AryNoBlanks)

And i get the error: 1004 unable to get the average property of the worksheetfunction class

Am i just miss-using the command or do i need to make a function that cycles through the whole array?

 

[mikerickson]

How is AryNoBlanks determined. How is it dimensioned and what is in it?

 

[steve the fish]

If the values in the array are derived from cells then check for an error cell.

 

[Lavina]

After checking your post i noticed in my locals that the type is string... happened after the 2d into 1d arrray change, thanks for pointing me to my mistake!