Runtime error 1004 on MMULT in VBA

[lingkai]

Hi,

Encountering this error on MMULT in VBA - would anyone be able to help me review and point out my mistakes please?

Runtime error 1004: Application-defined or object-defined error

Here's part of the code (pardon the clumsiness):


Range("B7").Select
CriteriaCount = Range(Selection, Selection.End(x1Down)).Rows.Count

'mmult code

Range("F10").Select
Do Until IsEmpty(ActiveCell.Value)

ActiveCell.Offset(0, CriteriaCount + 3).Value = WorksheetFunction.MMult(WorksheetFunction.MInverse(Range(Selection, Selection.End(x1Right))),Range(ActiveCell.Offset(0, 7), ActiveCell.Offset(CriteriaCount, 7)))
ActiveCell.Offset(1, 0.).Select

Loop


Thanks for your help!

 

[lingkai]

You're a genius! It works!
Thank you so much!