VBA Array display problem
 

Hello,

I have a VBA function which returns an Array of text values. But when I
enter the formula in a cell, only the first element of the array is
shown in the cell.
How can I display the full array in one or more cells ?

thanks,
Johan

VBA Array display problem
 

Hi Johan,

Try selecting sufficient cells to display the array values and array enter
the formula, i.e. confirm entry to the range with CTRL+SHIFT+ENTER.


---
Regards,
Norman



"johanvdv" wrote in message
oups.com...
Hello,

I have a VBA function which returns an Array of text values. But when I
enter the formula in a cell, only the first element of the array is
shown in the cell.
How can I display the full array in one or more cells ?

thanks,
Johan