Styles.Add Method

  • Article
Excel Developer Reference

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

Syntax

expression.Add(Name)

expression   A variable that represents a Styles object.

Parameters

Name Required/Optional Data Type Description
Name Required String The new style name.

Return Value
A Style object that represents the new style.

Example

This example defines a new style based on cell A1 on Sheet1.

Visual Basic for Applications 
  With ActiveWorkbook.Styles.Add("theNewStyle")
    .IncludeNumber = False
    .IncludeFont = True
    .IncludeAlignment = False
    .IncludeBorder = False
    .IncludePatterns = False
    .IncludeProtection = False
    .Font.Name = "Arial"
    .Font.Size = 18
End With

See Also