I have an array variable which contains 50 values between 1 and 11.
myValue(0) = 5, myValue(1) = 10, myValue(2) = 6 etc

Is there an easy way to get the sum of this array?
x = worksheetfunction.sum(myValue)? (I know this doesn't work).

Or do I need to do a For j = 0 to 49, Next j loop and sum as I go.

Thanks in advance.

Daniel