title: Match function? VBA not working properly
body: <p>I have a following code and i have "name" in cells B11 , B19 and B25 and i was expecting a result of 19 or 25 with the code but it returns Y=1. Could anyone tell me what is the problem?.</p>
  
  <pre><code>Sub mat()
  
  Y = Application.Match("name", ActiveSheet.Range("B19:B30"), 0)
  MsgBox Y
  
  End Sub
  </code></pre>