array and CTRL+SHIFT+ENTER

[Nicolas]

Hi,

I have a user defined function in an xll add-in that is returning an array.
But the dimensions of the array returned can differ from call to call.

Is there a way to produce this scenario with Excel C API.

* the user select a single cell
* the user enter a function name and args
* the user press CTRL+SHIFT+ENTER
* the user defined function returns and array of x by y and the user can see
it

Thanks

Nic

 

[Stephen Bullen]

Hi Nicolas,

I have a user defined function in an xll add-in that is returning an array.
But the dimensions of the array returned can differ from call to call.

Is there a way to produce this scenario with Excel C API.

The best newsgroup for C API questions is Public.Excel.sdk

Regards

Stephen Bullen
Microsoft MVP - Excel

Professional Excel Development
The most advanced Excel VBA book available
www.oaltd.co.uk/ProExcelDev