title: Copy all the cells in a column
body: <p>I have a sheet which has 200 rows with some blanks in between.</p>
  
  <p>I cannot use <code>End(xlDown)</code> or <code>End(xlUp)</code> to get the entire range because there are blank rows. </p>
  
  <p>How can I copy up to the last range which has data in columns?</p>
  
  <p>Also, I don't want to copy the headers.</p>
  
  <p>Kindly suggest how I can do this in Excel VBA.</p>