Edit

Styles.Add method (Excel)

  • Article

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.

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

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.