On Thursday, October 3, 2013 2:51:16 AM UTC-7, Claus Busch wrote:
Hi Howard,



Am Thu, 3 Oct 2013 02:48:21 -0700 (PDT) schrieb Howard:



If rngBig Is Nothing Then ... etc.



dim rngBig as Range

This will create a range with all found cells



The new answer:

Dim i as integer

Dim varOut() as Variant





Regards

Claus B.


Sweet, thanks a lot.

Regards
Howard