Custom Array Functions
In general array formulas get entered into multiple cells at the same
time (using ctrl+shift+enter), so whereas you can't return a 12-member
array to a single cell, you *can* return it to 12 cells.
Tim.
"moi" wrote in message
...
...........
Finally you say
- DispArray = aAd
and there it goes wrong. You have an array with 12 elements, so now
you should specify the element to return
DispArray = aAd(a_number)
Because you can't return an Array with 12 values into one single
cell,
DispArray = aAd will return 0.
|