matrix arithmetic using arrays in vba
 

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

matrix arithmetic using arrays in vba
 

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