View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
nicgendron[_8_] nicgendron[_8_] is offline
external usenet poster
 
Posts: 1
Default Returning array ...


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