View Source

The REMOVE command is used to remove a name, sheet, sheet cell styles, print area, rows and columns.

Command	Keyword	Value	Developer notes
REMOVE	OBJECT	*NAME
REMOVE	NAME	value	Required. name.

    REMOVE NAME(TOTAL)

Command	Keyword	Value	Developer notes
REMOVE	OBJECT	*SHEET
REMOVE	SHEET	value	Optional. A specific sheet name can be entered otherwise the current context sheet is used.

    REMOVE OBJECT(*SHEET)

    REMOVE OBJECT(*SHEET) SHEET(Sales)

Command	Keyword	Value	Developer notes
REMOVE	OBJECT	*CELLSTYLE
	SHEET	value	Optional. A specific sheet name can be entered otherwise the current context sheet is used.
	SHEET	*ALL	The special value of *ALL will clear all added cell styles for all sheets.

    REMOVE OBJECT(*CELLSTYLE)

    REMOVE OBJECT(*CELLSTYLE) SHEET(*ALL)

    REMOVE OBJECT(*CELLSTYLE) SHEET(Sales)

Command	Keyword	Value	Developer notes
REMOVE	OBJECT	*PRINTAREA
REMOVE	SHEET	value	Optional. A specific sheet name can be entered otherwise the current context sheet is used.

    REMOVE OBJECT(*PRINTAREA)

    REMOVE OBJECT(*PRINTAREA) SHEET(Sales)

Command	Keyword	Value	Developer notes
REMOVE	OBJECT	*ROW
	SHEET	value	Optional. A specific sheet name can be entered otherwise the current context sheet is used.
	RANGE	n n.n	Required. Range of rows. A single row number or two comma separated row numbers to specify a range of rows.

    REMOVE OBJECT(*ROW) RANGE(5)

    REMOVE OBJECT(*ROW) RANGE(5,6)

    REMOVE OBJECT(*ROW) RANGE(5,6) SHEET(Sales)

Command	Keyword	Value	Developer notes
REMOVE	OBJECT	*COLUMN
	SHEET	value	Optional. A specific sheet name can be entered otherwise the current context sheet is used.
	RANGE	n n.n	Required. Range of columns. A single column number or two comma separated column numbers to specify a range of columns.

    REMOVE OBJECT(*COLUMN) RANGE(5)

    REMOVE OBJECT(*COLUMN) RANGE(5,6)

    REMOVE OBJECT(*COLUMN) RANGE(5,6) SHEET(Sales)