title: Excel 2010 VBA - runtime error 1004 - using match to copy range from one sheet to another
body: <p>i can't see where i've gone wrong</p>
  
  <pre><code>Dim Sheet1RowNumber As Variant, Sheet28RowNumber As Variant, sStaffName As String
  sStaffName = Worksheets(1).Cells(7, 1).Value
  Sheet28RowNumber = Application.Match(sStaffName, Worksheets(28).Range("a:a"), 0)
  Sheet1RowNumber = Application.Match(sStaffName, Worksheets(1).Range("a:a"), 0)
  Worksheets(1).Range(Cells(Sheet1RowNumber, 2), Cells(Sheet1RowNumber, 8)) =        Worksheets(28).Range(Cells(Sheet28RowNumber, 2), Cells(Sheet28RowNumber, 8))
  </code></pre>