Microsoft KB Archive/132439

= Last Cell Detected Incorrectly After Change Row Height =

Article ID: 132439

Article Last Modified on 8/19/2003

-

APPLIES TO


 * Microsoft Excel 95a
 * Microsoft Excel 5.0c
 * Microsoft Excel 5.0a for Macintosh

-



This article was previously published under Q132439



SYMPTOMS
In Microsoft Excel, when you change the row height on your worksheet or macro sheet from the default, the last cell on the worksheet is not detected correctly.



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.
 * 1) Select the affected rows and apply the original row height formatting.



STATUS
Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article. This problem was corrected in Microsoft Excel 97 for Windows and Microsoft Excel 98 Macintosh Edition.

Additional query words: 5.00c 7.00a XL7 XL5 XL

Keywords: KB132439

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.