I have date in the first 50 rows of a worksheet.

If I delete rows 10 through 100 by using either:

rows("10:100").select
selection.delete

or

rows("10:100").select
selection.clear

then I should only have data in the first 9 rows.

I have a function that is relying on the used range. I
would expect the following to return an address that ends
in row 9. However it returns an address that ends in row
100.

UsedRange.SpecialCells(xlCellTypeLastCell).Address

Any ideas why row 100 is still in the used range??? TIA...