title: Excel Macro / VBA - How do I delete an entire row if a cell in one column is blank?
body: <p>I want a macro code that (1) starts at Row 3, (2) and deletes any row where its cell in Column B is blank. I've tried... </p>
  
  <pre><code>Sub DelBlankRows()  
      Columns("B:B").Select  
      Selection.SpecialCells(xlCellTypeBlanks).Select  
      Selection.EntireRow.Delete  
  End Sub
  </code></pre>
  
  <p>And </p>
  
  <pre><code>Sub delrows()  
       Range("B:B").SpecialCells(xlCellTypeBlanks).EntireRow.Delete  
  End Sub
  </code></pre>