(Solved) – Error in finding last used cell in Excel with VBA

  • by
(solved)-–-error-in-finding-last-used-cell-in-excel-with-vba

When I want to find the last used cell value, I use:

Dim LastRow As Long

LastRow = Range("E4:E48").End(xlDown).Row

Debug.Print LastRow

I am 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?

Leave a Reply

Your email address will not be published. Required fields are marked *