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.

REFERENCES

"Microsoft Excel Product Support Help," version 4.0, "Answers to Common Questions"

KBCategory: kbdocerr

KBSubcategory:
Additional reference words: 4.00 4.00a

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Microsoft KB Archive/107542

Contents