I thought you said it was a worksheet with a matrix?

you can send me a workbook



--
Regards,
Tom Ogilvy


ajames54 wrote in message
...
On Mon, 9 Feb 2004 11:45:19 -0500, "Tom Ogilvy"
made this cogent remark :

something like 50x50 is the max (KB 166342) for ANY matrix
calculation
Limitations you cite have to do with things like MINVERSE (not array
formulas in general). If you are just talking about an array formula,
250 x
250 should not be a problem in XL97. It may be a problem in xl95 or
earlier.

There is no registry setting which changes these limits.


It wouldn't be the first time I've gone down the wrong path...
But for some reason or another every other computer I've tried to run
this on fails at exactly the same size ... I get the #VALUE! error at
73 items or more.

Would you be willing to look at my code?