Hi flow23,

To solve the speed issue, eliminate as many arrays as possible. They
are notoriously slow for large spreadsheets. e.g. Try entering the
formula I'd suggested as they are not arrays.


--
John James
------------------------------------------------------------------------
John James's Profile: http://www.excelforum.com/member.php...o&userid=32690
View this thread: http://www.excelforum.com/showthread...hreadid=531468