If I'm interpreting this correctly, it appears the limit is the number of
rows in XL 2007, i.e., approx. 1 million:
http://support.microsoft.com/default.aspx/kb/166342

Dave
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.


"jimr315" wrote:

I have searched MS.com for any clue as whether the array size limit has
improved in the latest version of excel. If it has not changed, I am not
going to get it.