View Single Post
  #1   Report Post  
Jeff
 
Posts: n/a
Default 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