Hi,

I use this code to find the last row in an excel spreadsheet:

ActiveCell.SpecialCells(xlCellTypeLastCell).Select
iLastRow = ActiveCell.Row

But if I erase this last cell and I ask the program for the new last cell, it gives me the old last cell ???

Does anybody knows how to find the new last cell ?