title: Why isn't the Range.Find method finding the first instance of a string?
body: <p>In the range <code>A1:I1</code>, the exact string "*ContactName" appears twice - once in <code>A1</code> and again in <code>I1</code>. <a href="https://i.stack.imgur.com/uvNIq.png" rel="nofollow noreferrer">Here is a link to a picture of the range.</a></p>
  
  <p>My code below returns 9 when I expected in to return 1.</p>
  
  <p>Please could someone explain why? I have read Microsoft's documentation but still can't figure it out: <a href="https://msdn.microsoft.com/en-us/library/office/ff839746.aspx" rel="nofollow noreferrer">https://msdn.microsoft.com/en-us/library/office/ff839746.aspx</a></p>
  
  <pre><code>Sub FindCol()
      Dim destinationCol As Integer
      destinationCol = Range("A1:I1").Find("*ContactName").Column
      MsgBox destinationCol
  End Sub
  </code></pre>
  
  <p>If I alter the code to start from column I then, as expected, the method loops back around and returns 1 (column A).</p>
  
  <pre><code>Sub FindCol()
      Dim destinationCol As Integer
      destinationCol = Range("A1:I1").Find("*ContactName", after:=Cells(1, 9)).Column
      MsgBox destinationCol
  End Sub
  </code></pre>