Denial and Jeord,
I didn't want to calculate the array elements twice (it is a lengthy calculation), so I used Jeord's workaround and it works fine. Thanks, gentlemen. It is truly a luxury to have access to your expert advice.
Lasercat
Thanks for your prompt reply!
Now, have you ever figured out a way to make Excel use non-adjacent cells as the output elements of an array formula? Excel's Help file says that the ctrl key can select groups of non-adjacent cells, but I haven't been able to make that work when defining cells to...
Mutt-
Thanks for your posting about creating a function that returns an array. I've tried it, and as usual with any Microsoft product the devil is in the details, especially in the statements that dimension the arrays and return the final values.
So, could I impose on you to provide a simple...
