Microsoft KB Archive/73561

{|
 * width="100%"|

Macro Recorder Improperly Records CTRL+SHIFT+ARROW Keys

 * }

-

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.

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(&quot;fred&quot;,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 :

Technology :