title: Find last used cell in Excel VBA
body: <p>When I want to find the last used cell value, I use:</p>
  <pre><code>Dim LastRow As Long
  
  LastRow = Range(&quot;E4:E48&quot;).End(xlDown).Row
  
  Debug.Print LastRow
  </code></pre>
  <p>I'm getting the wrong output when I put a single element into a cell. But when I put more than one value into the cell, the output is correct.
  What's the reason behind this?</p>