5.5.9 REMOVE

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

REMOVE NAME

Syntax:

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

 

Example

REMOVE NAME(TOTAL)

 

REMOVE SHEET

Syntax:

Command	Keyword	Value	Developer notes
REMOVE	OBJECT	*SHEET
	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.
		*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
	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)