I just discovered that using the UsedRange property (in Excel 2000) causes
Excel to "clean up" any cells below and to the right of the UsedRange that
used to have data in them. In other words, after calling UsedRange,
Ctrl+End will take you to the cell at the intersection of the last row and
last column of actual data, not to where the last cell of data used to be.
It used to be that you had to save the workbook for this "clean up" to be
done.

--
Regards,
Bill Renaud