Array

[Guest]

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??

 

[Don Guillett]

Have a look at the help index for SUMPRODUCT

 

[Alan Beban]

Have a look at the help index for SUMPRODUCT

Can you give an example; at first blush it seems that SUMPRODUCT will
return a scalar, not an array.

Alan Beban