5 4 9 REMOVE

You are here:

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

REMOVE NAME

Syntax:

Example

REMOVE NAME(TOTAL)

REMOVE SHEET

Syntax:

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.

Example

REMOVE OBJECT(*SHEET)

REMOVE OBJECT(*SHEET) SHEET(Sales)

REMOVE CELL STYLE

Syntax:

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.

Example

REMOVE OBJECT(*CELLSTYLE)

REMOVE OBJECT(*CELLSTYLE) SHEET(*ALL)

REMOVE OBJECT(*CELLSTYLE) SHEET(Sales)

REMOVE PRINT AREA

Syntax:

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.

Example

REMOVE OBJECT(*PRINTAREA)

REMOVE OBJECT(*PRINTAREA) SHEET(Sales)

REMOVE ROW

Syntax:

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.

Example

REMOVE OBJECT(*ROW) RANGE(5)

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

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

REMOVE COLUMN

Syntax:

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.

Example

REMOVE OBJECT(*COLUMN) RANGE(5)

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

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