If you save the workbook after the deletion of the unnecessary row/column, the usedrange property will reset.