title: Why my macro doesn't delete all the rows (VBA)
body: <p>i have this macro it is supposed to delete all the cells that doesnt have a background set to them, but when I execute the macro if two or more contiguous cells doesnt have a background it only deletes one of them, here is the code: </p>
  
  <pre><code>Sub Macro1()
          Dim a As Range
  
          Set a = Hoja1.Range("A1:A12")
          For Each cell In a
              If cell.Interior.ColorIndex = xlNone Then
                  cell.EntireRow.Delete
              End If
          Next
  End Sub
  </code></pre>