yogeshparte
New Member
- Joined
- Apr 3, 2006
- Messages
- 1
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
--------
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
--------