hi

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

ramki - 28 Feb 2006 10:41 GMT

hi
can any one help me in regard of matrix functions

i have to write some functions on matrix so i just wanna see how the
internal coding of mmult or minverse etc... i mean i want to know how an
excel matrix function treats variables, as range or anything else...???

if some body can send me a code of simple matrix function i will be able to
understand the syntax.

thank you

Reply to this Message

Chris Marlow - 28 Feb 2006 12:51 GMT

Ramki,

Do you need help with the Maths or the Excel?

Are you trying to write VBA code to manipulate matrices?

Both MMULT & MINVERSE take ranges of cells as inputs. They are also array
formulae, which means you commit them to a range of cells using
CTRL-SHIFT-ENTER.

Regards,

Chris.

Signature

Chris Marlow
MCSD.NET, Microsoft Office XP Master

> hi
> can any one help me in regard of matrix functions
[quoted text clipped - 7 lines]
>
> thank you

Reply to this Message

Tom Ogilvy - 28 Feb 2006 13:00 GMT

Public Function MyFunc(rng1 as Range, rng2 as Range)
Dim v as Variant, i as Long, j as Long
v = rng1.Value
for i = 1 to ubound(v,1)
for j = 1 to ubound(v,2)
v(i,j) = v(i,j) * rng2(i,j)
next
next
Myfunc = v
End function

The function would need to be array entered in the worksheet.

Signature

Regards,
Tom Ogilvy

> hi
> can any one help me in regard of matrix functions
[quoted text clipped - 7 lines]
>
> thank you

Reply to this Message