Hello
Assume myFunc(...) is a UDF that return an array.
Assume this UDF is used in a range on a spreadsheet:
Within the VBA code of this UDF, I would like to know the space available on the sheet for the UDF results.
In the example above, I would like to code this kind of thing:
Where I hope to get nRows=7 and nCols=4, since the UDF has been used in the range A2:D8 in this example.
Would be very useful to have that because this would tell me how much results I need to return.
Assume myFunc(...) is a UDF that return an array.
Assume this UDF is used in a range on a spreadsheet:
range A2:D8
{=myFunc(...)}
Within the VBA code of this UDF, I would like to know the space available on the sheet for the UDF results.
In the example above, I would like to code this kind of thing:
Code:
Function myFunc(...)
...
nRows = ...
nCols = ...
...
End Function
Where I hope to get nRows=7 and nCols=4, since the UDF has been used in the range A2:D8 in this example.
Would be very useful to have that because this would tell me how much results I need to return.