And make sure you delete the rows, not just "Clear Contents".


Gord Dibben Excel MVP

On Thu, 1 Dec 2005 15:15:36 +0100, "Niek Otten" wrote:

After deleting the rows, save the file. That will set the new last cell.