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’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? … Read more