Functions with multiple inputs?

  • Thread starter Thread starter Nicolas Laudato
  • Start date Start date
N

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
 
suggest you post your question to an Excel newsgroup. this newsgroup answers
questions about using macros in MS Access relational database software.
 
Hi Nicolaus,
heres a simple example:

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