View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tim Williams Tim Williams is offline
external usenet poster
 
Posts: 1,588
Default 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.