DELETE.STYLE

Macro Sheets Only

Equivalent to choosing the Delete button from the Style dialog box, which appears when you choose the Style command from the Format menu. Deletes a style from a workbook. Cells formatted with the deleted style revert to the Normal style.

Syntax

DELETE.STYLE(style_text)

Style_text is the name of a style to be deleted. If style_text does not exist, DELETE.STYLE returns the #VALUE! error value and interrupts the macro.

Remarks

You can only delete styles from the active workbook. External references are not permitted as part of the style_text argument.

Related Functions

APPLY.STYLE Applies a style to the selection

DEFINE.STYLE Creates or changes a cell style

MERGE.STYLES Merges styles from another document into the active document

List of Command-Equivalent Functions