Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to use function that returns array of variable size?
I have a VBA function that returns an array of variable size.
How do I use it in the spreadsheet without knowing the size (and perhaps not even the shape) a priori? Consider the following trivial example: function mytest() dim myarr(3,1) myarr(0,0) = 1: myarr(1,0) = 2: myarr(2,0) = 3 mytest = myarr end function Normally, I use it by highlighting 3 cells in a column, enter =mytest(), then press ctrl-shift-Enter. But what if I did not know the function returned 3 elements, but (a) I knew the shape, or (b) I did not even know the shape? Ideally, I would like to highlight just the upper-left corner (like cut-and-paste of multiple cells), enter =mytest(), and press ctrl-shift-Enter. Of course, that does not have the desired effect (namely, filling in adjacent with cells with the entire array result). |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Array function that returns values within several intervals | Excel Worksheet Functions | |||
Using Array variable in FIND function | Excel Programming | |||
Using Array variable in FIND function | Excel Programming | |||
Define an array with variable size | Excel Programming | |||
How to find out the size of a variable-size array ? | Excel Programming |