Array
 

How do multiply 2 arrays to generate another array. Say

Dim one as integer
Dim two as integer
Dim three as integer

one = range ("a1:a10").value
two = range ("b1:b10").value

So is it three = one.value * two.value??


--
Thanks!

Array
 

Have a look at the help index for SUMPRODUCT

--
Don Guillett
SalesAid Software

"Daviv" wrote in message
...
How do multiply 2 arrays to generate another array. Say

Dim one as integer
Dim two as integer
Dim three as integer

one = range ("a1:a10").value
two = range ("b1:b10").value

So is it three = one.value * two.value??


--
Thanks!