Matrix Multiplication in VBA and storing values in another matrix

Hi,

MMULT (MACIERZ.ILOCZYN in Polish) following Office help:
Zwraca iloczyn macierzowy dwóch tablic. Wynik jest tablicą o takiej samej liczbie wierszy jak tablica1 i takiej samej liczbie kolumn jak tablica2.


Your ArrC is defined as

Please Login or Register  to view this content.

so 1 row only

and ArrW as

Please Login or Register  to view this content.

- 1 column only

so result of

Please Login or Register  to view this content.

will be 1 row x 1 column (scalar value)

Are you aware of that?

May be - yes, because you try to assign result to scalar (single element of 2d table) here:

Please Login or Register  to view this content.

But as we see code only and no data (sample workbook) we (or at least myself) cannot say anything more :-)

Kaper,

thank you for your engagement and remarks. I agree with your that a file says more than 1000 words. link removed - please attach here, as requested

Thanks to your explicit remarks I figured out my error! Sometimes you have to hear/read something that is obvious to be able to awake. Thank you for that!!!

Kind regards
anwid

Please follow our standard way to attach files to forum posts. My network restrictions do not allow me to open files from
ufile dot io
server

---
Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.