I have a sheet. I select all of it and "Deleted" it's contents a couple of different ways.

After I've "deleted" and run this code
With ActiveSheet
Last_Row = .Range("A1").SpecialCells(xlCellTypeLastCell).Row
End With

"Last_Row" comes up with 3163 in it. How do I get it to say "0"?

The one solution I've found (but this isn't really practical) is to delete the rows, save the entire work sheet, close it, and read it back in. But I need to do these deletions under VBA code control.

Tnx, Mac