Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Adding Arrays
Hi,
I currently use a macro to aggregate an array of cashflows. I use paste special values add to aggregate a series of equal sized arrays which is the output from a model. However, the output array is large, i.e. 10 columns x 360 rows, so performance is slow. Is using arrays in VBA faster. I would have to import the array from the spreadsheet for each array into VBA and then do the array addition and then export the array back to the spreadsheet. Is this the most efficient way to do this type of cashflow aggregation? Does anyone have any better ideas? Thanks for your help |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Arrays | Excel Worksheet Functions | |||
Use of arrays | Excel Worksheet Functions | |||
Arrays | Excel Discussion (Misc queries) | |||
vba adding arrays | Excel Discussion (Misc queries) | |||
Arrays | Excel Worksheet Functions |