title: Simulate Ctrl+Down Arrow
body: <p>Create a table and insert 2 rows of data and then insert 8 blank rows into the table</p>
  
  <pre><code>ThisWorkbook.ActiveSheet.Cells.Range("A1").Select
  Selection.End(xlDown).Select
  MsgBox Selection.row
  </code></pre>
  
  <p>returns row 3</p>
  
  <pre><code>ThisWorkbook.ActiveSheet.Cells.Range("A1").End(xlDown).row
  </code></pre>
  
  <p>returns row 11</p>
  
  <p>The <em>End Method</em> is behaving differently how can I make it behave like the Selection version?<br>
  Edit: One more detail, ClearContents and then Insert the rows with VBA</p>