title: For each loop in VBA unexpectedly skipping rows
body: <p>I have written this code, that is part of a bigger problem. Initially it was supposed to start transfer some data from a worksheet to another.. but it keeps skipping rows, it copies one, skips then copies the other one, skips ,copies,skip... I am using the Select method just to test, instead of copy.</p>
  
  <pre><code>Dim sharepointSheet As Worksheet
  Dim masterSheet As Worksheet
  Dim sharepointTable As Range
  
  'Auxliary variable
  Dim row As Range
  Dim cell As Range
  Dim RowLast As Long
  
  
  
  Set sharepointSheet = ThisWorkbook.Worksheets("Sharepoint List")
  Set masterSheet = ThisWorkbook.Worksheets("Master List")
  
  Set sharepointTable = masterSheet.Range("A2", "F133")
  
  
  For Each row In sharepointTable.Rows
      row.Cells(row.row, 3).Select
  
     ' RowLast = masterSheet.Cells(Rows.Count, "A").End(xlUp).row + 1
     ' masterSheet.Cells(RowLast, "A").PasteSpecial
  
  Next row
  </code></pre>