Hi there

Is it possible to do simple matrix arithmetic without looping through all
the individual items in an array?

I'd prefer not to use Excel's built-in functions, but this may not be
possible. If this is the only way to do it, I heard from someone that there
is a way to use Excel's built-in MMULT function to do matrix addition and
subtraction. How would I do this?

Best regards
Loane

Loane Sharp wrote:
Hi there

Is it possible to do simple matrix arithmetic without looping through all
the individual items in an array?

I'd prefer not to use Excel's built-in functions, but this may not be
possible. If this is the only way to do it, I heard from someone that there
is a way to use Excel's built-in MMULT function to do matrix addition and
subtraction. How would I do this?

Best regards
Loane


Do you mean VBA arrays or arrays of values in ranges on the worksheet?

Alan Beban