Thread: Using Find as lookup method goes to semi endless loop
View Single Post
  #11   Report Post  
Posted to microsoft.public.excel.programming
L. Howard L. Howard is offline
external usenet poster
  
Posts: 852
Default Using Find as lookup method goes to semi endless loop
On Sunday, June 22, 2014 5:02:52 AM UTC-7, Claus Busch wrote:
Hi Howard,



Am Sun, 22 Jun 2014 04:27:39 -0700 (PDT) schrieb L. Howard:



Thar works fine.



to make the code a bit more universal you can also work with UsedRange:


Regards

Claus B.

--


Great, now one can either set the 'search' area to exclude certain cells using code ...3() or go with UsedRange for all cells using code ...4().

Thanks again Claus.

Regards,
Howard
Reply With QuoteReply With Quote