Last Row in Excel

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 ?

My guess(!) is that you need to delete the last cell, not erase it.

Thank you HBR, I tried what you told me but the result was the same as above...

Another suggestion ?

Thank you Nitro, your code exactly fit my purpose and thank
you Lyla, I've found a lot of useful tips on this site...

Nankien