Macro Recorder Improperly Records CTRL+SHIFT+ARROW Keys

 Last reviewed: November 4, 1994
Article ID: Q73561
The information in this article applies to:
  • Microsoft Excel for Windows, versions 2.x, 3.0, 4.0
  • Microsoft Excel for OS/2, versions 2.2, 3.0

SUMMARY

The Macro Recorder in Microsoft Excel records CTRL+SHIFT+ARROW keys as static SELECT statements. These SELECT statements will not have the same effect as the keystrokes when applied to blocks of data that may move or vary in size.

MORE INFORMATION

Workaround

Edit the macro to contain code that duplicates the effect of the keystroke.

The following macro will have the same effect as a CTRL+SHIFT+DOWN ARROW: 

   =SET.NAME("fred",ACTIVE.CELL())
   =SELECT.END(4)
   =SELECT(fred:ACTIVE.CELL(),fred)
The codes to perform CTRL+SHIFT+UP ARROW, LEFT ARROW, or RIGHT ARROW operations are substantially similar; the only thing that must be changed is the number in the SELECT.END statement. The following are the numbers that can be used with SELECT.END: 

Parameter   Direction
---------   ---------

   1        Left
   2        Right
   3        Up
   4        Down
The following macro code will duplicate CTRL+SHIFT+END: 

   =SET.NAME("fred",ACTIVE.CELL())
   =SELECT.LAST.CELL()
   =SELECT(fred:ACTIVE.CELL(),fred)
The following code will duplicate CTRL+SHIFT+HOME: 

   =SELECT(TEXTREF("!R1C1"):ACTIVE.CELL(),ACTIVE.CELL())

REFERENCES

"Function Reference," version 4.0, pages 378-382

"Microsoft Excel Function Reference," version 3.0, pages 209-213

"Microsoft Excel Functions and Macros," version 2.x, pages 349-351

KBCategory: kbprg kbmacro
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 dynamic control movement

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 4, 1994
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.