title: ActiveSheet.UsedRange.Rows.count giving wrong and different result on each run
body: <p>My Worksheet has 29 rows and 39 columns. 
  Currently I use </p>
  
  <p><code>lrow = ActiveSheet.UsedRange.Rows.count</code>   --> for getting used rows count<br>
  <code>lColumn = ActiveSheet.UsedRange.Columns.count</code>  --> for getting used columns count </p>
  
  <p>Excel gives wrong count every time it runs. Sometimes it gives:<br>
  Rows: 29 Columns: 784<br>
  On other runs it gives<br>
  Rows: 32755 and Columns as: 784<br>
  and on other runs it gives different values. </p>
  
  <p>I have checked there is no junk data after 29 rows and after 39 columns. Also, 
  Previous to filling the data I clear the sheet with: <code>ActiveWorkbook.Worksheets("Field Difference").Cells.Delete</code></p>
  
  <p>I hope <code>ActiveWorkbook.Worksheets("Field Difference").Cells.Delete</code> completely clears the sheet and clears the sheet of the junk data if any on the sheet. How else I can make sure that there is no junk data in the worksheet.  </p>
  
  <p>I do understand that we have other Options such as:<br>
  <code>ActiveWorkbook.Worksheets("Field Difference").UsedRange.ClearContents</code> - to clear only contents<br>
  <code>ActiveWorkbook.Worksheets("Field Difference").UsedRange.Clear</code> - to clear formatting as well. </p>
  
  <p>Please do let me know why I am getting wrong values for the count of rows and columns and what is the way out. Can I use <strong>any other reliable way</strong> to get the <code>UsedRange</code> row count and <code>UsedRange</code> columns count. </p>