Multiplying Arrays

[berabus]

Hi

anyone know the best way to multiply multiple arrays?

I have 3 1D arrays W(), Wpos() & Wflag()

i want to multiply each value in the array by the corresponding value in the other arrays

any advice please?

B

[teylyn]

maybe use the worksheet function SUMPRODUCT(). It is designed to do just what you're describing.

[zbor]

maybe would be usefull to upload example file and explain problem.

[berabus]

maybe use the worksheet function SUMPRODUCT(). It is designed to do just what you're describing.

Thanks Teylyn, tired this

Please Login or Register  to view this content.

but no avail?

What do you think

[teylyn]

This

Please Login or Register  to view this content.

is missing several commas and a few brackets. Check your syntax.

[broro183]

hi Berabus,

Welcome to the Forum
I may be misunderstanding your question (or example) but... is there any particular reason why you are trying to do the multiplication in code rather than directly in the worksheet?
Doing it directly in the worksheet is likely to be much quicker than looping cell by cell, especially if your real data set is large.
From the example above, it appears that you could type

Please Login or Register  to view this content.

into cell C2 & copy it down as far as you need. If you really want this in a macro, you could record a macro of your actions as you do this.

hth
Rob