title: Finding the last used cell in a spreadsheet
body: <p>I need ur help to automate one MIS Report. </p>
  
  <p>Description: Daily we will circulate MIS by downloading the open items lying in GL. Total no of line items will vary on daily basis. I have created a macro where i have selected Range from first item to last one(5800 Line items). But on day 2 it would increase to 6500 as i have only selected range as 5800..system is showing an error. Instead of specific range selection can we fix some thing like 10000 Items ? or System should automatically select the entire range based on the number of transactions. </p>
  
  <p><code>Range("C5881").Select</code></p>