Microsoft KB Archive/107542

= Microsoft Knowledge Base =

Excel: SELECT.LAST.CELL Example Incorrect in PSS Help
Last reviewed: September 12, 1996

Article ID: Q107542

The information in this article applies to:

- Microsoft Excel for Windows, versions 4.0 4.0a - Microsoft Excel for the Macintosh, version 4.0

SYMPTOMS
In question number 20 of the Product Support "Answers to Common Questions" Help file in Microsoft Excel, the macro example for selecting the last cell is incorrect. The error occurs in the SELECT.LAST.CELL macro function. In this help file, the function contains the argument 4. However, because 4 is not a valid argument for the SELECT.LAST.CELL function, the following error message appears if the formula is entered as described in the help file:

Error in Formula

RESOLUTION
To correct this problem, change the following line of code from:

=SELECT.LAST.CELL(4) to:

=SELECT.LAST.CELL

STATUS
Microsoft has confirmed this to be a problem in Microsoft Excel version 4.0. We are researching this problem and will post new information here as it becomes available.