title: Select Cells in Range until row is blank
body: <p>I have a spread sheet that will always be from Columns A to I but the range of the amount of rows can vary. I want to Select all cells in range (A1:I20000) until the first blank cell in column A, so if the data ends at 202 it will stop selecting the rows at line 202.</p>
  
  <p>I tried writing my own formula but unfortunately columns B, C, E, and H continued to select down to row 20000</p>