.UsedRange sometimes doesn't update properly.
.Cells(Rows.Count, "E").End(xlUp).Row
does the equivalent you selecting the bottomost cell in column E (probably E1048576) then on the keyboard tapping End then the up arrow.