View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Erich Neuwirth Erich Neuwirth is offline
external usenet poster
 
Posts: 41
Default 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?