Thread: vba adding arrays

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

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)


"Jeff" <Jeff@discussions.microsoft.com> wrote in message
news:063A87A2-EB26-4D75-9A47-E6D766250DFE@microsoft.com...
> 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