| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Contents of an array
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Contents of an array
How do you know x = worksheetfunction.sum(myValue) doesn't work?
It does! "Daniel Bonallack" wrote in message ... 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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Contents of an array
Oh. I got an error, but maybe that was for another reason. I'll go back to
the code and try again. Thanks for helping. Daniel "Bob Umlas" wrote: How do you know x = worksheetfunction.sum(myValue) doesn't work? It does! "Daniel Bonallack" wrote in message ... 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| does an array contain contents of cell | New Users to Excel | |||
| How do I concatenate the contents of an array in Excel? | Excel Worksheet Functions | |||
| Need help displaying array contents | Excel Programming | |||
| Dumping the contents of a VBA array to a sheet | Excel Programming | |||
| Randomize the order of the contents of an array | Excel Programming | |||
Linear Mode
