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)

  • No labels