title: Excel VBA to delete blank rows within a range
body: <p>I have worksheet that have data starting at A84, extending to column X. I use this VBA to select the entire range of data.</p>
  
  <pre><code>Dim Lastrow As Integer
  Lastrow = Range("A:Z").Find("*", , , , xlByRows, xlPrevious).Row
  
  Range("A84:X" &amp; Lastrow).Select
  </code></pre>
  
  <p>Within that selected range, I need it to detect which rows are blank from columns A to Z and delete them. If there's data after column Z, the row should be deleted because I'm considering it blank.</p>