SEND.KEYS Command Equivalent for Parentheses in Excel

Last reviewed: November 2, 1994
Article ID: Q61352

The information in this article applies to:

Microsoft Excel for Windows, versions 2.x, 3.0, 4.0, 5.0
Microsoft Excel for OS/2, versions 2.2, 3.0

SUMMARY

The equivalent of parentheses with the SEND.KEYS() command is SEND.KEYS("{(}...{)}"). The parentheses must be within a set of curly braces. This also holds true when using square brackets within the SEND.KEYS() command.

Any special character, such as plus sign (+), minus sign (-), multiplication sign (*), percent sign (%), and exponentiation sign (^), must also be enclosed in a set of curly braces.

MORE INFORMATION

Example

Original formula: =A1*(A2+9)

Macro command: =SEND.KEYS("{F2}{BS}{BS}{BS}{-}11{)}~")

Resulting formula: =A1*(A2-11)

Note: the information above also applies to version 5.0 only when using version 4.0 macro language.

REFERENCES

"Function Reference," version 3.0, pages 165-166, 214-215 "Functions and Macros," version 2.x, page 321, 353-354, 373

KBCategory: kbusage
KBSubcategory:
Additional reference words: 2.0 2.00 2.01 2.1 2.10 2.2 2.20 2.21 3.0 3.00
4.0 4.00 4.0a 4.00a 5.0 5.00

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.