Ok, I found an answer, it is to pass
xltypeMulti | xlbitDLLFree in the xltype member of XLOPER
but now, another question appears :
The function is returning an array of size x and y where x and y ar
subject to change from time to time.
To see all the results, I have to select an x by y array, put a formul
in it and then press CTRL+SHIFT+ENTER.
Is there a way to simplify this process.
An example could be to select only one cells, enter the formula, pres
CTRL+SHIFT+ENTER (or not ..) and then you receives an output of x b
y.
Thanks
Ni
--
nicgendro
-----------------------------------------------------------------------
nicgendron's Profile:
http://www.excelforum.com/member.php...fo&userid=2515
View this thread:
http://www.excelforum.com/showthread.php?threadid=39650