Returning arrays
INDEX into it like this
=INDEX(myfunc(A1:A5),3)
--
HTH
Bob
(there's no email, no snail mail, but somewhere should be gmail in my addy)
"Steve" wrote in message
...
I have written a user defined function that returns an array.
I want to insert this function into a cell on my worksheet and have a
specific member of the array appear in the cell.
What is the syntax for the formula in the cell on the worksheet that will
access a specific element in the array returned from my function?
Thanks in advance for your help.
|