| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Array formula range size
I am currently fighting with array formulas in different versions of Excel.
It seems that up to Excel XP there is a restriction for the result of UDFs which return arrays of about 5000 cells. On the other hand, TRANSPOSE for an array of size 100x100 seems to work. Is there an overview of what works and what does not work for the sizes of array formula results? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using Named Range within an Array Formula | Excel Discussion (Misc queries) | |||
| different formula for ROW, array / range? | Excel Discussion (Misc queries) | |||
| array formula with a dynamic range. | Excel Worksheet Functions | |||
| Array Formula, noncontigous range | Excel Worksheet Functions | |||
| Create and Array formula using range names | Excel Programming | |||
Threaded Mode
