Multiplying Arrays

[slumeet]

This one I thought would be easy but it's turning out to stump me. Here is the correct code of one of my macros:

Please Login or Register  to view this content.

What I'm trying to do here is match the data from WB (inputs) to WB2 (data) and spit out the result. It works fine. Now I would like to multiply each value referenced in WB2 tab1 by each value referenced in WB2 tab 2 and have that result spit out into my inputs WB. I tried and this is what I came up with:

Please Login or Register  to view this content.

It doesn't like the red lines of code. Not sure where to go from here... Mostly concerned with the array I think since the stuff after seems to have less to do with the arithmetic I'm trying to execute.