How to For Loop two ArrayLists

[edTech]

How do I loop two arraylists and multiply each one? For example first element(0) in array 1 multiply first element(0) in array 2 and then element 2 to element 2.

I started with this For loop in VbScript, but it calculates the first one but then when it moves to the second element the element(1) in array 2 multiplies with element(0) in Array 1 which is not what I want.

For each z in Array1
For each x in Array2
Calc = z*x
next
next

Any help would be most appreciated.

 

[Fluff]

Assuming they are both 1d arrays, how about

For i = LBound(Array1) To UBound(Array1)
   Calc = Array1(i) * Array2(i)
Next i