Need Help: Problem with MMULT function for large matrices

[yogeshparte]

Hello!
I am using VBA for Excel 2002 and facing problem to use worksheet function Mmult. I want to multiply X1[4X5] matrix with X2[5X1422] matrix. The code I wrote is as follows

With Application.WorksheetFunction

X1 = Range("B4:F7").Value
X2 = .Transpose(Range("H20:L1422").Value)
Y = .Transpose(.MMult(X1, X2))
End With

If I run this code I get the error no. 1004. All entries in Matrix X1 and X2 are double and non-empty.
However, if I reduce X2 matrix size to [5X1360] code runs without any errors producing correct results. How can I solve this problem? I have sample size of 1422 and not 1360.
With regards,
YP
--------

 

[Oaktree]

Referencing http://www.mrexcel.com/archive/Formulas/6487.html (see the very bottom of the thread), it seems "the maximum number of elements in array that can be passed 'to Excel using the Excel Transpose function is 5461.'"

So, your returning a 4x1422 (5688 cell) array exceeds Excel's array limitations.

 

[Aladin Akyurek]

Referencing http://www.mrexcel.com/archive/Formulas/6487.html (see the very bottom of the thread), it seems "the maximum number of elements in array that can be passed 'to Excel using the Excel Transpose function is 5461.'"

So, your returning a 4x1422 (5688 cell) array exceeds Excel's array limitations.

Yep. Morefunc's Math functions like MMULT.EXT allows for processing larger matrices.