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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sum with matrix functions? 8
Can I write a function like matrix function? 2
Need help with basic covariance function 0
Search for maximum set of values 5
Access Dcount (multiple criteria) 3
How fix a too long array function 5
Matrix Operations (MInvert Function) 1
How to calculate a Max / min in a matrix 1

Back
Top