Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All
Expand Minimize

Range.Style Property

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



expression   A variable that represents a Range object.


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

Visual Basic for Applications
Worksheets("Sheet1").Range("A1").Style.Name = "Normal"

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

Visual Basic for Applications
If Worksheets("Sheet1").Range("B4").Style.Name = "Normal" Then
    Worksheets("Sheet1").Range("B4").Style.Name = "Percent"
End If

Community Additions

© 2015 Microsoft