Macro Error with CTRL+ENTER Key Combination

Last reviewed: November 2, 1994
Article ID: Q66635

SUMMARY

If you use the key sequence CTRL+ENTER, which is used in charting to enter text on more than one line, a problem may occur when editing that line in a macro. Specifically, if you edit a text entry that has more than one line, the next select statement that doesn't select a multiline text entry will cause a macro error.

The following is an example:

               A
   1       =SELECT("Title")
   2       =SELECT("Text S2P3")
   3       =RETURN()

If "Title" was a two-line text entry such as "Microsoft

                                             Corporation"

and "Text S2P3" was a one-line text entry such as "Point3", the macro above would produce an error when it gets to the second Select statement.

Recording and running a macro like the one above will produce the same error. However, if "Text S2P3" was a two-line text entry, the macro would run without producing an error.

Microsoft Excel for Windows version 3.00 works as expected and will generate no error of this type.

KBCategory: kbother
KBSubcategory:
Additional reference words: noupd

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.

Last reviewed: November 2, 1994
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.