S
SantaClaus
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!
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!