title: Excel VBA - selecting range to last completely blank row
body: <p>I have some VBA code that needs to select a range from A84 to X. I'm using this code to select that range to the last row in the data.</p>
  
  <pre><code>Dim Lastrow As Integer
  Lastrow = ActiveSheet.Cells(Rows.Count, 1).End(xlUp).Row
  
  Range("A84:X" &amp; Lastrow).Select
  </code></pre>
  
  <p>This stops at the first row with a blank cell in the A column. I need it to check columns A through Z, not just A. For example, if there is a value in column A on rows 84 to 94, but for row 95, there's only data in column F or R, it won't include row 95. How can this look at columns A:Z to determine whether or not the row is blank?</p>