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