title: Deleting empty rows - MS Excel using VBA
body: <p>I am using following VBA to delete all the rows that does not have * in Column T. It works but it only deletes 1 row at a time. I have to run the vba 25 times in order to delete 25 rows that does not have * in the column T. Do you see anything wrong with the code?</p>
  
  <pre><code>Sub DeleteCells()
  
      'Loop through cells A1:A10 and delete cells that contain an "x."
      For Each c In Range("t1:t35")
          If c &lt;&gt; "*" Then c.EntireRow.Delete
      Next
  
  End Sub
  </code></pre>