Bob -

I was wondering if there is any way of forcing excel to output the
complete array? <

I don't think so. If it's a User Defined Function, it can only return values
to the worksheet cells where it resides. I think the only thing you can do
is encourage your users to select a very large range before array-entering
the function. As I recall, the extra cells will display the #N/A error code.

- Mike Middleton
http://www.DecisionToolworks.com
Decision Analysis Add-ins for Excel



"Bob" wrote in message
...
Hi Everyone:

In excel, I am writing a function that returns an array, for example a
matrix. This function is called from the formula bar of the spreadsheet,
and returns the results to the spreadsheet. However, the array only fills
the cells that the user has selected prior to typing the name of the
function, its arguments and finally hitting Ctrl-Shift-Enter. I was
wondering if there is any way of forcing excel to output the complete
array? For example, if the user has selected 3x3 cells, but my output is
5x5, for my function to show the result of all 5x5 elements?

Thanks for all your help.

Bob