Knowing the dimensions of a spilled array
Need formula functions to get the dimensions (row count and column count) of a spilled array.
or a sort of "Append" function for the spilled arrays, to append multiple spilled arrays after one another.
I need to place some text, and / or another spilled array, below a spilled array.
Ute Simon commented
COUNT, ROWS and COLUMNS work for spilled arrays. Just reference the start cell of the array as A1# (with the #). These wil show you the total number of cells resp. number of columns or number of rows.
Peter Bartholomew commented
The dimension issue is possible using existing worksheet functions
= ROWS( UNIQUE(list) )
From VBA, n = rng.Rows.Count works OK.
Appending additional data below a spilt array could be useful as an inbuilt function and is something Charles Williams MVP addresses in his FXLSpeedTools.