EDIT.DELETE

Macro Sheets Only

Equivalent to choosing the Delete command from the Edit menu. Removes the selected cells from the worksheet and shifts other cells to close up the space.

Syntax

EDIT.DELETE(shift_num)
EDIT.DELETE?(shift_num)

Shift_num is a number from 1 to 4 specifying whether to shift cells left or up after deleting the current selection or else to delete the entire row or column.

Shift_num Result

1 Shifts cells left

2 Shifts cells up

3 Deletes entire row

4 Deletes entire column

• If shift_num is omitted and if one cell or a horizontal range is selected, EDIT.DELETE shifts cells up.
• If shift_num is omitted and a vertical range is selected, EDIT.DELETE shifts cells left.

Related Function

CLEAR Clears specified information from the selected cells or chart

List of Command-Equivalent Functions