title: Get row index of last non-blank cell.
body: <p>I'm new to coding macros and just had a quick question. What I have been trying to do is select all the data points before an empty cell, then store the row index of the last point. For example, in the code below I would select rows 1-4 and the row index that would be stored is 4.  I have this code so far which selects the data points:</p>
  
  <pre><code>Cells(2, 2).Select
  Range(Selection, Selection.End(xlDown)).Select 
  </code></pre>
  
  <p>I just need to store the last row index. Example data:</p>
  
  <pre><code>1. 342
  2. 342
  3. 324
  4. 234
  5. &lt;This would be an empty cell&gt;
  6. 43242
  7. 342
  8. 32423
  9. 4324
  </code></pre>