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