Hi Nicgendron,

To see all the results, I have to select an x by y array, put a formula
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, press
CTRL+SHIFT+ENTER (or not ..) and then you receives an output of x by
y.

Unfortunately not. Also, questions related to xlls are better asked in
the Public.Excel.sdk newsgroup.

Regards

Stephen Bullen
Microsoft MVP - Excel

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