title: Which is faster and more efficient - For loop, MATCH, FIND, etc?
body: <p>What I am doing is search some strings one by one in the entire range - like search for "blah1", if found then exit, else search "blah2" in the entire range in the same manner.  "blah's" are searched in one column.</p>
  
  <p>Right now i am just running a For loop code as shown below which so far works ok in my tests...but was wondering if MATCH, FIND or other methods may be faster...any opinion?</p>
  
  <pre><code>Sub test()
  
  Dim LR As Long
  LR = Sheet1.Cells(Rows.Count, "A").End(xlUp).Row
  
  If Cells(1, "B") = "" Then
  For i = 1 To LR
  If Cells(i, "A") = "blah1" Then
  Cells(1, "B") = Cells(i, "A").Row
  Cells(1, "C") = Cells(i, "A")
  Exit For
  End If
  Next i
  End If
  
  If Cells(1, "B") = "" Then
  For i = 1 To LR
  If Cells(i, "A") = "blah2" Then
  Cells(1, "B") = Cells(i, "A").Row
  Cells(1, "C") = Cells(i, "A")
  Exit For
  End If
  Next i
  End If
  
  End Sub
  </code></pre>