Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi all, I'm using Excel 2003.
Is there a way to quickly sum two arrays together in VBA, so that Array3(r,c)=Array1(r,c)+Array2(r,c) ? where r = row number, c = column number, Array1 and Array2 are the input arrays and Array3 is the output of the calculation I searched this and other forums, and tried several things, but the only solution I found was to write a function which loops through all the items one by one. It works, but it's pretty slow and I was hoping for a faster solution, as I have to run this on a rather large file. In Matlab and other environments it's as easy as writing Array3 = Array1 + Array2 Is there really no equivalent in VBA? :( Thanks! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Trouble with arrays (transferring values between two arrays) | Excel Programming | |||
Use of arrays | Excel Worksheet Functions | |||
Working with ranges in arrays... or an introduction to arrays | Excel Programming | |||
Arrays - declaration, adding values to arrays and calculation | Excel Programming | |||
Arrays | Excel Programming |