title: VBA LastRow calculation not working
body: <p>I have a worksheet with an autofiltered range that starts in cell <code>B3</code>. Column <code>A</code> contains some macro buttons but is effectively blank. The top two rows contain information about the data in the main range.</p>
  
  <p>In VBA, I am using what I believe is a standard method for determining the last row in a worksheet (In this case I cannot rely on the <code>.End</code> method on a single column):</p>
  
  <pre><code>LastRow = Activesheet.Cells.Find("*",SearchOrder:=xlByRows,SearchDirection:=xlPrevious).Row
  </code></pre>
  
  <p>However, sometimes this returns a value of one, even when I have thousands of rows of data. It seems to only do this when there are filters set (but there are still visible rows with data in them), but even then it doesn't always happen and I can't see a pattern to it.</p>
  
  <p>I know there are other solutions - I have changed to a <code>UsedRange</code> technique instead, but it is very frustrating that this particular one fails as it would otherwise be the most effective one in this situation.</p>
  
  <p>Does anyone know why this would be happening? </p>