REMOVE

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

To remove a name, use the OBJECT keyword with a value of *NAME.

 

                                                         Required

 

 REMOVE ----- OBJECT ----------- *NAME ------------------------->

 

          >-- NAME ------------- value -------------------------|

 

Keywords

OBJECT

*NAME

NAME

Name.

To remove a sheet, use the OBJECT keyword with a value of *SHEET.

 

                                                         Required

 

 REMOVE ----- OBJECT ----------- *SHEET ------------------------>

 

                                                         Optional

 

          >-- SHEET ------------ value -------------------------|

 

Keywords

OBJECT

*SHEET

SHEET

A specific sheet name can be entered otherwise the current context sheet is used.

 

To remove added sheet cell styles, use the OBJECT keyword with a value of *CELLSTYLE.

 

                                                         Required

 

 REMOVE ----- OBJECT ----------- *CELLSTYLE -------------------->

 

                                                         Optional

 

          >-- SHEET ------------ value -------------------------|

                                 *ALL

 

Keywords

OBJECT

*CELLSTYLE

SHEET

A specific sheet name can be entered otherwise the current context sheet is used.
The special value of *ALL will clear all added cell styles for all sheets.

 

To remove a sheet print area, use the OBJECT keyword with a value of *PRINTAREA.

 

                                                         Required

 

 REMOVE ----- OBJECT ----------- *PRINTAREA -------------------->

 

                                                         Optional

 

          >-- SHEET ------------ value -------------------------|

 

Keywords

OBJECT

*PRINTAREA

SHEET

A specific sheet name can be entered otherwise the current context sheet is used.

 

To remove rows, use the OBJECT keyword with a value of *ROW.

 

                                                         Required

 

 REMOVE ----- OBJECT ----------- *ROW -------------------------->

 

          >-- RANGE ------------ n,n --------------------------->

 

                                                         Optional

 

          >-- SHEET ------------ value -------------------------|

 

Keywords

OBJECT

*ROW

SHEET

A specific sheet name can be entered otherwise the current context sheet is used.

RANGE

Range of rows. A single row number or two comma separated row numbers to specify a range of rows.

 

To remove columns, use the OBJECT keyword with a value of *COLUMN.

 

                                                         Required

 

 REMOVE ----- OBJECT ----------- *COLUMN ----------------------->

 

          >-- RANGE ------------ n,n --------------------------->

 

                                                         Optional

 

          >-- SHEET ------------ value -------------------------|

 

Keywords

OBJECT

*COLUMN

SHEET

A specific sheet name can be entered otherwise the current context sheet is used.

RANGE

Range of columns. A single column number or two comma separated column numbers to specify a range of columns.