EDIT.DELETE macro

Equivalent to clicking the Delete command on 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

 

 

Related Function

CLEAR   Clears specified information from the selected cells or chart

Return to index