Hi

highlight the range you want the matrix to be in so if my matrix is 3x3
then I would highlight the matrix A1:C3. Then enter the matrix formula
and then hold down CRTL-Shift and press enter. This should fill in the
whole matrix with the formula you entered.

Hope this works... its been a while since I used MMULT().

Tom



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/