Solved

# Multiplying an Array by another Array

Posted on 2011-02-11

I have a Range **rngRow("H14:N14") **that is populated with values. Depending on the values, the Locals Window shows that:

rngRow.Value2.Value2(1,1) = 10

.Value2.Value2(1,2) = 30

.

.

.Value2.Value2(1,12) = 300

The second array is a series of 12 constants with a Defined Name **CatCost** or {1,2,3,4...12}

I would like to either multiply or divide the** rngRow.Value2** Array by the **CatCost **array and those values become a third array.

**varResult = rngRow.Value2 * vCost ** 'It would become an array with 12 calculated values

*Is there a method for performing multiplication or division on two arrays of equal numbers?*

or I guess another option or way of explaining would be:

**varResult = Range1("A1:A12") * Range2("C1:C12") **

which is ultimately what I would like to have the flexibility to perform.