Macro Sheets Only
Selects the cell at the edge of the range or the first cell of the next range in the direction specified. Equivalent to pressing CTRL+ARROW in Microsoft Excel for Windows or COMMAND+ARROW in Microsoft Excel for the Macintosh.
Syntax
SELECT.END(direction_num)
Direction_num is a number from 1 to 4 indicating the direction in which to move.
|
Direction_num |
Direction |
|
1 |
Left (equivalent to CTRL+LEFT ARROW or COMMAND+LEFT ARROW) |
|
2 |
Right (equivalent to CTRL+RIGHT ARROW or COMMAND+RIGHT ARROW) |
|
3 |
Up (equivalent to CTRL+UP ARROW or COMMAND+UP ARROW) |
|
4 |
Down (equivalent to CTRL+DOWN ARROW or COMMAND+DOWN ARROW) |
Related Function
SELECT.LAST.CELL Selects the last cell on a worksheet or macro sheet that contains a formula, value, or format or that is referred to in a formula or name
List of Command-Equivalent Functions