title: VBA Cut to Range is Skipping 2nd Row
body: <pre><code>For Each cell In Range("A2:A" &amp; Cells(Rows.Count, 1).End(xlUp).Row)
  cell.EntireRow.Cut Workbooks("Book2.xlsx").Worksheets("Sheet1").Cells(Rows.Count,1).End(xlUp).Offset(1, 0)
  Next cell
  </code></pre>
  
  <p>Gotta quick question. This piece of code loops through a range, and cuts the entire row / pasting it onto another workbook/worksheet.</p>
  
  <p>However, it cut/pastes the FIRST row successfully.  It then skips the 2nd row.  And continues after that as expected, cutting/pasting every row (in fact if i set a breakpoint, you can see it hit the first row, skip the 2nd, then run fine &amp; hit all others (H2, H4, H5, etc.).  If I change the method to "COPY", it runs fine (H2, H3, H4, etc.).</p>
  
  <p>Note: I can use 'COPY' or some other workarounds.  But really am just wondering why 'CUT' behaves this way.</p>
  
  <p>UPDATE: Sorry, I've update the code to CUT instead of COPY.  And yea, I understand that that I need a header row in the target sheet.  My only question is why the 2nd row is never cut from the source sheet (But when I replace CUT with COPY it works just fine).</p>