title: Select multiple ranges with VBA
body: <p>I need to select multiple ranges in a worksheet to run various VBA code on them. The ranges will always begin on row 84 but the end depends on how far down the data goes. I've been selecting these ranges separately using code like this:</p>
  
  <pre><code>Sub SelectRange()
  Dim LastRow As Integer
  LastRow = ActiveSheet.Cells(Rows.Count, 1).End(xlUp).Row
  Range("A84:B" &amp; LastRow).Select
  End Sub
  </code></pre>
  
  <p>That works fine, but I can't figure out how to select multiple ranges at once. I've tried everything I can think of:</p>
  
  <ul>
  <li>Range("A84:B", "D84:E", "H84:J" &amp; LastRow).Select</li>
  <li>Range("A84:B,D84:E,H84:J" &amp; LastRow).Select</li>
  <li>Range("A84:B &amp; LastRow,D84:E &amp; LastRow,H84:J &amp; LastRow").Select</li>
  </ul>
  
  <p>Nothing works. I get a run-time error when running any of those.</p>