Hello,
I have two matrices A = [1] and B = [4 3 0]
[0]
[2]
And i have to multiply these two...
The question asks me to use cells procedure and the output of my matrix code should be printed on the worksheet.
Please help T.T
Hello,
I have two matrices A = [1] and B = [4 3 0]
[0]
[2]
And i have to multiply these two...
The question asks me to use cells procedure and the output of my matrix code should be printed on the worksheet.
Please help T.T
by the way, demension for matrix for A is 3 x 1 and B is 1x3
Assume A is in A1:A3 and B is in C1:C3
* Select a 3x3 target range
* Enter the formula =MMULT(A1:A3;C1:E1)in top left cell
* Complete with Ctrl + Shift + Enter
Edit: Oops! Did you want the VBA code and not the formulas? Sorry, my misstake
Last edited by Jacc; 10-16-2012 at 03:55 AM.
<----- If you were helped by my posts you can say "Thank you" by clicking the star symbol down to the left
If the problem is solved, finish of the thread by clicking SOLVED under Thread Tools
I don't wish to leave you with no answer, yet I sometimes miss posts. If you feel I forgot you, remind me with a PM or just bump the thread.
Check out Dana DeLouis post in this link: http://www.pcreview.co.uk/forums/exc...-t3851454.html
Looks pretty neat.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks