hi
 

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

hi
 

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.

--
Chris Marlow
MCSD.NET, Microsoft Office XP Master


"ramki" wrote:

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

hi
 

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.

--
Regards,
Tom Ogilvy




"ramki" wrote in message
...
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