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.

More like a colleague to me!

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


Makes sense! The error handling was needed to keep the msgbox code
together. Though your idea escapes the loop if there are no blanks.
Better approach IMO.

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion