Range.Style property (Excel)

Returns or sets a Variant value containing a Style object that represents the style of the specified range.

Syntax

expression.Style

expression A variable that represents a Range object.

Example

This example applies the Normal style to cell A1 on Sheet1.

Worksheets("Sheet1").Range("A1").Style = "Normal"

An alternative is the following.

Worksheets("Sheet1").Range("A1").Style = ThisWorkbook.Styles("Normal")

If cell B4 on Sheet1 currently has the Normal style applied, this example applies the Percent style.

If Worksheets("Sheet1").Range("B4").Style = "Normal" Then 
 Worksheets("Sheet1").Range("B4").Style = "Percent" 
End If

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.