title: Find the last filled row in a filtered column without dropping the Autofilter
body: <p>How do I get the position of the last non-empty cell in a filtered column without dropping the applied Autofilter? I understand it's easy to get the number of the last <strong>visible</strong> row with</p>
  
  <pre><code>Dim ws as Worksheet, rng As Range
  Set rng = Range(Letter &amp; 1 &amp; ":" &amp; Letter &amp; 1) ' where Letter is the letter code of the column
  GetLastVisibleRow = ws.Range(Split(ws.Cells(, rng.Column).Address, "$")(1) &amp; ws.Rows.count).End(xlUp).row
  </code></pre>
  
  <p>but I need the number of the last <strong>filled</strong> row instead. At the same time, I'd like to avoid setting</p>
  
  <pre><code>ws.AutoFilterMode = False
  </code></pre>
  
  <p>if it's possible.</p>
  
  <p>Thanks in advance.</p>