SELECT.END

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