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. |
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. |