title: Excel Find Speed vs. VBA binary Search?
body: <p>How good/fast is Excel VBA's Find vs. binary search?  My platform is Office 11|2003 and I'll be searching for strings against Column A on three sheets of values.  Total number of rows ~140,000</p>
  
  <p>If worth it which Library &amp; functions should I reference to do the sorting and then the binary search?  Binary searching strings/text reportedly has potential problems. </p>
  
  <blockquote>
    <p>... one thing
    must be noted. Using binary search
    formulas with sortedtextrequires
    caution.  <a href="http://www.mrexcel.com/forum/showthread.php?t=84002" rel="noreferrer">Aladin A., Excel MVP</a></p>
  </blockquote>
  
  <p>Excel Find:</p>
  
  <pre><code>Worksheets(1).Range("A:A").Find("PN-String-K9", LookIn:=xlValues, LookAt:=xlWhole)
  </code></pre>