Styles.Add(String, Object) Method

Reference

Definition

Namespace:: Microsoft.Office.Interop.Excel

Assembly:: Microsoft.Office.Interop.Excel.dll

Important

Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.

Creates a new style and adds it to the list of styles that are available for the current workbook.

public Microsoft.Office.Interop.Excel.Style Add (string Name, object BasedOn);

Public Function Add (Name As String, Optional BasedOn As Object) As Style

Parameters

Name: String

Required String. The new style name.

BasedOn: Object

Optional Object. A Range object that refers to a cell that's used as the basis for the new style. If this argument is omitted, the newly created style is based on the Normal style.

Returns

Style

Remarks

If a style with the specified name already exists, this method redefines the existing style based on the cell specified in BasedOn.

Applies to