SEND.KEYS Command Equivalent for Parentheses in Excel

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

Additional query words: 2.0 2.00 2.01 2.1 2.10 2.2 2.20 2.21 3.0 4.0 4.0a 4.00a 5.0

Keywords :
Version :
Platform :
Issue type :