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.

The attached two files show different ways either of which hopefully will help in your project. They are very different approaches to different arrays.

Patrick

splitting-into-arrays-01.xls

ron-06.xls