title: Rows.Count returns the wrong number because?
body: <p>im trying to use</p>
  <pre><code>Dim sh As Worksheet, lastEmptyRow As Long, rngEmptyU As Range
   Set sh = ActiveSheet
   lastEmptyRow = sh.Range(&quot;X&quot; &amp; Rows.Count).End(xlUp).Row
   Set rngEmptyU = sh.Range(&quot;U&quot; &amp; lastEmptyRow + 1)
      rngEmptyU.Select
  </code></pre>
  <p>Rows.count returns value too big, although i even dont have any formulas in the columns.
  To double check, if i use the formula COUNTA in excel for example i have =IF(mdl!X1=&quot;&quot;,&quot;&quot;,mdl!X1)
  In this column would be 300 names, but COUNTA returns 1200 as all the rows that have this formula.
  Does anybody have some help for this, like change smth in the code?
  I hope i made clear, please ask if not.</p>