title: How to get the row count in EXCEL VBA
body: <p>I am developing a dashboard in excel. And I am looking for calculating row count. (How many records are present) .. </p>
  
  <p>Since there are some blank cells I thought to go from bottom to up. I use the following</p>
  
  <pre><code>   Range("A1048576").Select
  Selection.End(xlUp).Select
  </code></pre>
  
  <p>After this execution the active cell is at A113 which means the row count is 113.</p>
  
  <p>My question is how to get this number 113 from the active cell?</p>