title: Range.Find method in Excel VBA returning wrong row
body: <p>I am trying to search a string in excel using VBA .. for ex.<br>
  My sheet contains data as follows </p>
  
  <pre><code>1.Lalit
  2.Lalit
  </code></pre>
  
  <p>If there is only one row with occurrence of <code>lalit</code> it gives correct result while if there is 2 row with same string it returning the 2nd one as result instead of first. Please help me how to return correct row.</p>