Hello
Scenario: I have 2 separate dynamic arrays. I believe the arrays are 1-dimensonal each in that the array element values are gathered from a single row in excel.: E.g., array1 = range("h10: j10") , arry2 = range("h15:j15")
I'm want to multiply the first element in array1 by the first element in array2 and then move onto the 2nd element in array1 and multiply it by the 2nd element in array. so on and so forth until all elements in array 1 have been multiplied by their corresponding element in array 2. I'd like to hold the multiplied values in a third array and then make range("h20:j20") equal to the values in the third array.
worksheet example:
arry1 1, 4, 6
arry2 2, 3, 2
arry3 2, 12, 12
result:
h20: =2, i20: = 12, J20: = 12
thanks
Bookmarks