Multiply contents of two arrays then input result into an array

For such a simple problem, I am totally perplexed that I cannot find a solution in the internet (and I've been searching for like, ~12 hours for it, and no solution can be found). I'm a first-time user of VBA, so please spare me from the flames.

I cannot make this work:

Please Login or Register  to view this content.

ARRAYTEST function is just... a function (just to test if things work. I am aware of the keystroke to make array results come out using functions). In any case, the code goes like this: A1 to A3 cells are to Array 1, B1 to B3 cells are to Array 2 (ignore Array 3 and 4, just killing doubts from certain things). I wanted it such that Array 5's first data would contain the results of Array 1's first data multiplied to Array 2's first data; Array 5's second data would contain the results of Array 1's second data and Array 2's second data, so on and forth.

The problem is, whenever I run that code it chucks out an error pointing at this line >>

Please Login or Register  to view this content.

Can someone pinpoint what am I doing wrong? Or is there another way of doing it?

Thanks!

I found TMS' solution to be simpler for me though.

I have another problem, however. Given a new array I needed to get the sum product of three columns: the first two columns A1:A4, B1:B4, then the exponential of each column from N1 to Q4 divided by a constant T then store it to each element of the array:

=sumproduct(A1:A4,B1:B4,exp(N1:N4/T))
=sumproduct(A1:A4,B1:B4,exp(O1:O4/T))
=sumproduct(A1:A4,B1:B4,exp(P1:P4/T))
=sumproduct(A1:A4,B1:B4,exp(Q1:Q4/T))


This is the code:

Please Login or Register  to view this content.

I have to change ArrA(j, 1) to ArrA(j, 2) or something, though I don't know how to. When I do change it manually, the last cell would contain the correct answer. Please help.

This is the excel spreadsheet if it helps solving my last problem: array exercise.xlsm

Bump. Please help

Oh, thanks for replying again. I will post a new one as you suggested.

And amazingly (and sadly), no. I still have no idea how to code it, but I think I know how should it go: in that "For j" loop I would assign different columns or something.

I still have no idea how to do it though.

Hello, thanks for replying again.
I wanted to do what's in the sheet - as coded it's

Please Login or Register  to view this content.

I wanted to implement it in VBA but I am unable to - except when changing ArrA(j, 1) to (j, 2) manually then I would get the result for the second equation. array exercise.xlsm

Thanks for your help very much - I really appreciate it as I'm totally clueless on what to do, lol.

Yep, this is what I needed. Thanks a lot! :D