Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|