I am sorry you do need a sledgehammer. Try simulate this ~ Do anEdit/Delete/All for the cell just below the so called last cell (sayC10) your solution will give 11 and not 10. What we are detecting isthe last row that can be detected by the eyes.