B
Bob
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
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