Hi Garry,

Am Wed, 27 May 2015 05:03:18 -0400 schrieb GS:

This would be much faster if the range was large and no blank cells.

appreciate the praise of an expert.
If possible I rather check the occurance of that cell type than handle
an error when working with SpecialCells


Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional