STEP() Function Prevents SEND.KEYS from Working Correctly

Last reviewed: November 2, 1994
Article ID: Q62347

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, 2.21, and 3.0

SUMMARY

If the STEP() function is placed before a SEND.KEYS() function in a Microsoft Excel macro, the SEND.KEYS() function may fail to work as expected.

The following macro enters the word "test" into the active cell. The macro performs its function without the STEP() command, but the SEND.KEYS command is ignored if the STEP() function is entered first.

   =STEP()
   =SEND.KEYS("TEST~")
   =RETURN()

To avoid this behavior, use STEP() after the SEND.KEYS() function or remove the STEP() function.

Note: this is true for version 5.0 macro sheets, but not modules.

KBCategory: kbusage
KBSubcategory:
Additional reference words: 2.0 2.00 2.01 2.1 2.10 3.0 3.00 4.0 4.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.