title: Determining the last row in a single column
body: <p>I have a sheet with data in cols <code>A</code> through <code>H</code>.</p>
  
  <p>I need to determine the last row in column <code>A</code> that contains data (it's all contiguous - no gaps in the data/rows).</p>
  
  <p>There is also data in the other columns that have <em>more</em> rows of data than column <code>A</code>, so I need to isolate only column <code>A</code>. (And/or just a range within col <code>A</code>). </p>
  
  <p>I can do this on the spreadsheet level using </p>
  
  <pre><code>=COUNTA(A2:A100)
  </code></pre>
  
  <p>However in all of my researching for a Google Apps Script solution, all I seem to find are requirements to perform multiple functions encompassing dozens of lines of code - including plenty of <code>i++</code> stuff... Which I could do less complexly via offsetting directly from <code>A1</code>.</p>
  
  <p>Is there possibly a column-specific way of modifying this method?</p>
  
  <pre><code>var aLast = ss.getDataRange().getNumRows();
  </code></pre>
  
  <p>If a convoluted process is what is required, then so be it. But I find it difficult to imagine (and even more difficult to find!) a simpler solution.</p>
  
  <p>Does anyone care to enlighten me (or pop my bubble)?</p>