How to multiply two columns and get result in third range for a function

Hi everyone,
I've searched far and wide but I'm not really getting what I'm doing wrong. This is a really simple procedure that I need to understand to make more complicated functions. I am not making a sub or using a designated column on a worksheet, this needs to be a function so it has to be range/variable based. I'm not an expert on VBA so I apologize for any mishandlings of correct terms, I'll try my best.

What I want:
Input:
Column A: [3,4,8]
Column B: [7,3,11]
Output:
Column C: [21,12,88]

This is what I've been trying to use, and modifying to no avail:

Please Login or Register  to view this content.

I need to have the result display in a range like the index function does and the range itself needs to be able to be variable (not limited to a place on the worksheet, like the range that is chosen for the function can be 1-2 variables or 150 +. Of course for this to work the ranges A and B need to be equally long.

This would really further my understanding if I could work with ranges like this, thank you very much for reading

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however you need to include code tags around your code.

Please take a moment to add the tags. Posting code between [code]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/code] tags makes your code much easier to read and copy for testing, and it also maintains VBA formatting.

Please see Forum Rule #2 about code tags and adjust accordingly. Click on Edit to open your post, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

(Note: this change is not optional. As you are new here, I have done it for you this time.)

With all of the same caveats I include in this discussion about when array output is necessary and when we should perhaps avoid array output, it seems you are trying to do the exact same thing this user was doing, except you are multiplying where he/she was adding: https://www.excelforum.com/excel-pro...o-columns.html Review that thread and you should be able to come up with something that works.