title: Return a range from A1 to the true last used cell
body: <p>I'd like to select all the rows and columns in a spreadsheet. The macro needs to be dynamic, as the number of columns and rows tend to vary each time the macro would be called. It also needs to be able to account for blank rows and columns. </p>
  
  <p>This subroutine accomplishes part of the process:</p>
  
  <pre><code>Sub FindLastCell()
  Cells.Find(What:="*", After:=[A1], SearchDirection:=xlPrevious).Select
  End Sub
  </code></pre>
  
  <p>It finds and selects the very last cell in a spreadsheet. Now that I've found the very last cell in the spreadsheet, how do I select cell A1 to the LastCell as a range? </p>