title: VBA Syntax on Match Method
body: <pre><code>y = Application.WorksheetFunction.Match(51187, Sheets("New Master Data 6.1").Range(Cells(1, 1), Cells((Rows.Count), 1)), 0)
  </code></pre>
  
  <p>I cant find whats wrong with my syntax.  Help please :)</p>