View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
[email protected] jeff.j.griffith@gmail.com is offline
external usenet poster
 
Posts: 22
Default Functions with multiple inputs?

You could just have one input variable - try using a Collection and the
calling method can populate it with whatever you need in it. You can
then process through it using For...Next logic.



Nicolas wrote:
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