Hi Garry,

Nice technique with Tester01(). It's very fast on a long list.

Indeed, but it is worth noting that the SpecialCells method is subject to a
potential problem if the number of non contiguous areas exceed 8192:

http://support.microsoft.com/kb/832293/en-us


(Tester01() raises an error when the cells are filled)

That is why I added the error checking and the If Not Rng Is Nothing line.


---
Regards,
Norman


"GS" wrote in message
...
Hi Norman,

Nice technique with Tester01(). It's very fast on a long list.

The Worksheet_Change idea is probably the way to go.
<FWIW Tester01A() also works in there "as is". -very fast! (Tester01()
raises an error when the cells are filled)

Thanks and regards,
Garry