Home |
Search |
Today's Posts |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Adding 2 arrays, then use in worksheet function
If they're both coming from ranges, you could copy the first range into a
temporary range, then copy the second range and use copy|paste special|add and then pick up those new values. But that looks like it would be lots slower for summing 20 values. Rich_84 wrote: Hi, I have a macro which reads an excel range directly into an array, which I then can use in worksheet functions e.g.: DimMyArray As Variant Dim MyResult As Double MyArray = Range("A2:A21").Value MyResult = WorksheetFunction.NPV(0.1, MyArray) This seems to be really effective performance-wise, so my question is: is there a way to add together 2 identically sized arrays created in this way, but without just looping through the elements 1-by-1 (as this may be quite a drag on performance?). Thanks, Richard -- Dave Peterson |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adding to arrays | Excel Programming | |||
Arrays - declaration, adding values to arrays and calculation | Excel Programming | |||
vba adding arrays | Excel Discussion (Misc queries) | |||
Array function, two dimensions?? and worksheet arrays | Excel Programming | |||
Adding arrays | Excel Programming |