title: Select all data in sheet
body: <p>I am writing a macro that opens a New Workbook and copies all data to a different Workbook.
  The data always starts on C12 but we dont always know how many rows of data there are</p>
  
  <p>The following code is giving an error:</p>
  
  <pre><code>Workbooks("Somesheet.xls").Activate
  Sheets("Sheet1").Activate
   With Range("C12").Select
   End (xlDown)
   End With
  </code></pre>
  
  <p>How do I select all rows from C12?</p>