vba adding arrays

[Guest]

Hi

I am working with a lot of arrays, and I want to be sure that I am coding
most efficiently. I have to add multiply and divide arrays, so for example I
want to take
Array1(100) +5*Array2(100), but it doesnt look like I can just say

Array3(100)=Array1(100) +5*Array2(100)
I have to code

For i = 1 to 100
Array3(i)=Array1(i)+Array2(i)*5
Next i

Is that how you deal with arrays, by using For loops?

Thanks for your help

 

[Bob Phillips]

Yes, there is no array operators in VBA that I am aware of. You could dump
them to a worksheet range, create a formula to do it, then copy the result
back in, but for 100 elements, hardly worth the bother.

--

HTH

RP
(remove nothere from the email address if mailing direct)