Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I am trying to simulate the behaviour of an array multiplication such as
{=(A1:A10)*(B1:B10)} in VBA. The resulting array should contain: ={A1*B1, A2*B2, . . . , A10*B10}. I was hoping to avoid writing a loop if it is at all possible? I don't think there is a worksheetfunction which does this and I was hoping to avoid the loop: For i = 0 to Ubound(Temp1) Temp3(i) = Temp1(i)*Temp2(i) Next Is there an easy way to do this? Dan E |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
multiplication of two array in a particular way | Excel Worksheet Functions | |||
Multiplication | Excel Worksheet Functions | |||
multiplication | Excel Worksheet Functions | |||
Multiplication in one cell | Excel Discussion (Misc queries) | |||
Array multiplication addition | Excel Programming |