Last Cell Detected Incorrectly After Change Row Height

CAUSE

This behavior occurs when you change the row height on your worksheet or macro sheet to a value other than the default value. When you delete rows that contain data or formatting and then save the sheet, the address of the last cell is not reset if you have changed the default row height for this range.

For example, if you enter data in the range A1:C10 on a new worksheet, the last cell is cell C10. If you delete the data from rows 5 through 10, and save the file, the last cell should be cell C4. However, if you have changed the row height for rows 1 through 10, the last cell is still detected as cell C10, even after you save the file.

NOTE: This behavior does not occur in Microsoft Excel version 4.0.

WORKAROUNDS

To work around this problem, do the following:

1. Select the affected rows on the worksheet. (Note the original height of the rows.)
2. On the Format menu, point to Row, and then click AutoFit.
3. Save the file.
   
   When you use the Go To Special dialog box to select the last cell on the worksheet, the correct cell is now selected.
4. Select the affected rows and apply the original row height formatting.