That is not a limitation of arrays, 65535 is, but not 26. Must be something
else. I tried it and added a column in BJ and it worked fine still.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Montrose77" wrote
in message ...

I realise I'm responding to my own question, but just had the thought to
try reducing the range, and found that if I reduce it by one column (to
26 cells) then it works as expected.

I guess that is the limit to the array size Excel can handle.


--
Montrose77
------------------------------------------------------------------------
Montrose77's Profile:
http://www.excelforum.com/member.php...o&userid=18191
View this thread: http://www.excelforum.com/showthread...hreadid=571345