# Multiply array element values from 2 separate arrays

1. ## Multiply array element values from 2 separate arrays

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

2. ## Re: Multiply array element values from 2 separate arrays

Point of information: you have two other threads here where members have offered detailed help, and have responded to neither. Please go back and give some feedback - if the solution offered work, them mark the thread as solved and post to say thanks. If not, say thanks anyway for trying to help.

There are currently 1 users browsing this thread. (0 members and 1 guests)