"Alan Beban" wrote...
Unless you mean something odd by "invert matrix", there is no such
concept. Mathematically, the inverse of a matrix does not exist for
non-square matrices.

If you don't have a degree in a particular field, there's an outside chance
you don't know what you're talking about.

http://mathworld.wolfram.com/Moore-P...ixInverse.html

Chee Beng wrote:
MInverse function can return answer if array has an equal number
of rows and columns. Is there a known trick (any function or VBA)
to invert matrix which does not has an equal number of rows and
columns?

Do you mean a Moore-Penrose pseudoinverse? If so, follow the link above, and
see formula (7). Otherwise, follow this link.

http://mathworld.wolfram.com/Pseudoinverse.html

It's possibe Octave (the GNU Project's rough work-alike for MatLab) includes
source code for generalized matrix inverses.