do you use

OPTION EXPLICIT

as the first line of the code module?

"BEETAL" wrote:

With Application

matrixfinal = .MMult(mat1,mat2)

end with

The above programme works in one spreadsheet. The same syntax does not work
in another programme and "type mismatch" error comes as the answer.

What is the way Excel remembers a matrix created by a routine like
mat(1,Q) where q changes from 1 to 7 say. There are 7 elements. mat(1,1) to
mat(1,7). Now this is a row matrix,from the construction.
when I multiply this one with another 7x7 matrix ,by the above .MMult command
the type mismatch comes.

2. Then I tried changing both the matrix to 7X7. Yet again Type mismatch
error comes.

Going on for some time.

Dear MVPs and other experts, please help.

with regards

--
beetal