Matrix Multiplication in VBA

sheet 1 ----> [Matrix A]m*n Current Region for start --->cell A1
sheet 2 ----> [Matrix B]n*k Current Region for start --->cell A1

sheet 3 ----> [Matrix A]*[Matrix B]

I need to VBA code for Matrix Multiplication in sheet3 ,Just by pressing a button key (
In other words, no need to pick out the array of the matrix)

Can someone help me, Tanks

can you upload your example (as excel file)?

In other words,I do not want the formula MMULT to use because it requires the selection element has.

I did not need the file, sorry for requesting it.

find attached the solution, I hope it meets your needs.
Attachment 304067

I forgot to add a button. What you can do is press Alt-F8 and then run the macro MultiplyMatrices.

Milade
If the answers solved your problem, do not forget to mark the post [SOLVED]. You may also give reputation points to whoever helped you.

hsee,
Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.