Array of 100X250 as return of a user defined function?
Tom Ogilvy wrote:
Just for clarification, xl2000 is one of the versions limited as I stated.
(statement was about using the function in a worksheet as a UDF)
Perhaps Alan missed that you were using it as a UDF in the worksheet or was
suggesting a non worksheet workaround.
I was just making the point that the limitation is not a feature of the
TRANSPOSE function or of transferring data from an array to a worksheet
range, which will work on a large array if done by a Sub procedure; I
believe this is unlike versions earlier than xl2000, but I can no longer
check that.
Alan Beban
|