VBA: How to sum an array()

[Lokai]

What is the best way to sum values in an array()?
I can get a more complicated NPV like this x=npv(.1/12,arrayX()) but can I do a simple sum without looping thru the array?

 

[DRJ]

So you have an array called MyArray then

Application.WorksheetFunction.Sum(MyArray) will sum the array.

 

[Damon Ostrander]

Hi Lokai,

Simply use the Excel SUM() worksheet function, e.g.:

Xsum = WorksheetFunction.Sum(arrayX)

 

[Lokai]

Thank you both, I didn't realize that a worksheet function would work on a VBA generated array. Blinded by the not so obvious.

 

[DRJ]

Your Welcome

Take Care