Functions with multiple inputs?

[Nicolas Laudato]

I couldn't make a function with a matrix as input. My idea is to write a
macro (a function in VBA for Excel) witch reeds a matrix (of variable size)
and develops a number. The problem is that I can't find the way to write the
function with multiple inputs (like the function SUM(A1:A5) )

Does anyone knows how to do that?

Nicholas

 

[tina]

suggest you post your question to an Excel newsgroup. this newsgroup answers
questions about using macros in MS Access relational database software.

 

[bavariabob]

Hi Nicolaus,
heres a simple example:

Function MatrixArray(arange As Range)
MatrixArray = Application.WorksheetFunction.Sum(arange)
End Function