Last Row in Excel

[nankien]

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 ?

[HDR]

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

[nankien]

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

Another suggestion ?

[nankien]

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