title: Remove Blank Rows from an Excel Worksheet
body: <p>I've done some searching but I can't seem to find a quick method to get rid of all BLANK rows within a worksheet. I don't want it to take up much time. Is there such a way?</p>
  
  <p>I've tried a few methods that aren't brilliant that involve filtering blanks in all columns then deleting what's on screen. Maybe there's a function in excel that I'm missing here? </p>
  
  <p>I'm looking for something like the <code>UsedRange.RemoveDuplicates()</code> function that did a lot of work in a second or two.</p>