title: Find last non-empty row (cell) in column and ignore empty cells between values in column
body: <p><strong>Excel Spreadsheet:</strong>  </p>
  
  <pre><code>        A            B               C             D          E           F 
  1
  2
  3               List_A            List_B
  4               Product A    
  5               Product B   
  6                                 Product A
  7               Product C         Product B
  8       
  9               Product D         Product C
  10              Product E   
  11                                Product D
  12                                Product E
  13
  14
  </code></pre>
  
  <p>In the above Excel spreadsheet I have list of products in <code>Column A</code> and in <code>Column C</code>. <br>
  Both lists contain empty cells between the values in the column.</p>
  
  <hr>
  
  <p>Now, I want to identify the <strong>last non-empty row</strong> in both lists: <br>
  In <code>Column B</code> this would be <code>10</code> <br>
  In <code>Column C</code> this would be <code>12</code> <br></p>
  
  <hr>
  
  <p>Therefore, I tried to go with this <code>VBA</code>:</p>
  
  <pre><code>Sub Identify_last_Row()
  Last_Row_Number_Column_B = (Sheet1.Cells(Tabelle3.Range("B3").Row, Sheet1.Range("B3").Column).End(xlDown).Row)
  Last_Row_Number_Column_C = (Sheet1.Cells(Tabelle3.Range("C3").Row, Sheet1.Range("C3").Column).End(xlDown).Row)
  Sheet1.Range("D1").Value = Last_Row_Number_Column_B
  Sheet1.Range("E1").Value = Last_Row_Number_Column_C
  End Sub
  </code></pre>
  
  <p>This query goes through but it does not ignore the empty cells between the values in the column. <br></p>
  
  <p>How do I have to modify the code to identfy the <strong>last non-empty row</strong> and <strong>ignore the empty cells</strong> between the values in the column?</p>