It’s better to never delete a row: this will mess with both the autonumber and the row ID. Instead, consider just erasing the content of your unwanted row, but keep the actual row, and simply write your next entry over the one you would have wanted to delete.