title: Excel macro for selecting only half of the total number of rows in a worksheet
body: <p>I was wondering if someone can help me with this..</p>
  
  <p>I have about 500,000 rows in one excel sheet....and in others I have about 600,000 rows...</p>
  
  <p>So how do I select only half of the rows in the Excel... </p>
  
  <p>What I mean is suppose the total number is 500,000 rows...
  then I would like to select only half of it which is 250,000 rows...</p>
  
  <p>And copy that and put it new file and again apply the macro to select half of that i.e 125,000...</p>
  
  <p>Please suggest how to do that.</p>