title: How do I use xlCellTypeLastCell in VBA?
body: <p>I selected all cells in a sheet and Clear All to bring me a blank spreadsheet. Then I entered in E6 and A1 some texts. Then I ran the following code, however, I got E7 cell selected. How weird! I wonder if I missed something.</p>
  
  <pre><code>Sub Macro1()
      Cells.SpecialCells(xlCellTypeLastCell).Select
  End Sub
  </code></pre>