title: How to efficiently remove empty Excel rows using VBS?
body: <p>I need to remove the whole row IF <code>column A</code> value is empty. I have been doing it in excel and this method works best for me </p>
  
  <p><code>.Columns("a:a").SpecialCells(xlCellTypeBlanks).EntireRow.Delete</code> </p>
  
  <p>I need to do the same thing using <code>vbs</code> however, I have issues converting it to vbs </p>
  
  <p>How can I convert the above line into vbs?</p>
  
  <p>I looked up the <code>xlCellTypeBlanks = 4</code> using <code>F2</code> . But how to use the <code>SpecialCells</code> method ? </p>