Christian

Why not use the worksheet functions within VBA???

Application.WorksheetFunction.Mmult(Arg1, Arg2)

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
DTHIS
www.nickhodge.co.uk

FREE UK OFFICE USER GROUP MEETING, MS READING, 27th APRIL 2007
www.officeusergroup.co.uk

"Enrst-Christian Lehmann" wrote in message
...
Hello,

when I work with EXCEL, I sometimes use matrix functions. These
functions, in the German EXCEL they are called TREND or MMULT (just two
examples), are able to return more than one value to the EXCEL sheet.

Now, if I write a VBA function that calculates more than one number, would
it be possible to enable this function to behave like TREND or MMULT and
return more than one value to my EXCEL sheet?

If this is possible, then I would be happy to know about how to do this.
Thank you for any response in advance!

Christian Lehmann.