How to work with Matrices
Matrices could be a good alternative for when you start with bigger data and looping becomes slower. Normally should be fine with loops, but with that said. It could be useful to know that all things you do in excel can be done in vba as well, even processing matrices.
Sub Matrix()
'If incorrect Multiplication. #VALUE! will be on all cells that should be the result.
'Not really necessary to declare as they will be automatically variants.
'but could be good for practice purposes.
'Dim A as variant
'Dim B As Variant
'Dim C As Variant
A = Range("A2:B4") 'collecting matrix A
B = Range("D2:D3") 'collecting matrix B
'Calculating Matrix C with .MMult syntax.
C = Application.MMult(A, B)
'Printing out me new matrix C
Range("F2:F4") = C
End SubExample 1)
Example 2)
Example 3) - if your matrices don't match.
Learn more about VBA here for all my posts: https://www.pls-fix-thx.com/vba
If you have found this article or website helpful. Please show your support by visiting the shop below.