Macro Sheets Only
Equivalent to choosing the Clear command from the Edit menu. Clears contents, formats, notes, or all of these from the active worksheet or macro sheet. Clears series or formats from the active chart.
Syntax
CLEAR(type_num)
CLEAR?(type_num)
Type_num is a number from 1 to 4 specifying what to clear. Only values 1, 2, and 3 are valid if the selected item is a chart.
On a worksheet or macro sheet, or if an entire chart is selected, the following occurs.
Type_num Clears
1 All
2 Formats (if a chart, clears the chart format or clears pictures)
3 Contents (if a chart, clears all data series)
4 Notes (including sound notes; this does not apply to charts)
On a chart, if a single point, an entire data series, error bars, or a trend line is selected, the following occurs.
Type_num Clears
1 Selected series, error bars, or trend line
2 Format in the selected point, series, error bars, or trend line
If type_num is omitted, the default values are set as shown in the following table.
Active sheet Type_num
Worksheet 3
Macro sheet 3
Chart (with no selection) 1
Chart (with item selected) Deletes the selected item
Related Function
EDIT.DELETE Removes cells from a sheet
List of Command-Equivalent Functions