Microsoft KB Archive/61352

{|
 * width="100%"|

SEND.KEYS Command Equivalent for Parentheses in Excel

 * }

-

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(&quot;{(}...{)}&quot;). 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.

Example
Original formula: =A1*(A2+9)

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

Resulting formula: =A1*(A2-11)

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