Thanks for the memory jog.

But it did effect =index(), IIRC?????



Alan Beban wrote:

Dave Peterson wrote:
I would use 5 different worksheets (and hide the worksheets if that's
important). I think it would make updating the table easier (in general).

But using 5 names each an array 91 by 100 worked ok for me. But I think that
you'll need xl2002+ for this. xl2k (and earlier had a limit of 5461 elements,
IIRC).

That limit didn't apply to simply transferring arrays to worksheets or
vice versa.

Alan Beban

--

Dave Peterson