Macro Recorder Improperly Records CTRL+SHIFT+ARROW Keys

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

Additional query words:

Keywords :
Version :
Platform :
Issue type :