title: How to NOT skip empty rows or cells in vba?
body: <p>Is there any way to do a vba for each loop that loops a range but includes the empty cells/rows. </p>
  
  <p>PROBLEM: When I do a copy on the row from some other worksheet, the loop automatically skips the cells in the "A" column that are blank and skips that entire row completely and therefore I lose some data in that row because ONLY the A column is blank.</p>
  
  <p>eg. </p>
  
  <pre><code> For Each cell In wks.Range("A2", "A1000")
      cell.EntireRow.Copy Destination:=Worksheets("Master").Range("A65536").End(xlUp).Offset(1, 0)     
   Next cell
  </code></pre>