Share via

Style Object Members

  • Article
Excel Developer Reference

Represents a style description for a range.

Methods

  Name Description
Bb225711.methods(en-us,office.12).gif Delete Deletes the object.

Properties

  Name Description
Bb225711.properties(en-us,office.12).gif AddIndent Returns or sets a Boolean value that indicates if text is automatically indented when the text alignment in a cell is set to equal distribution (either horizontally or vertically.)
Bb225711.properties(en-us,office.12).gif Application When used without an object qualifier, this property returns an Application object that represents the Microsoft Excel application. When used with an object qualifier, this property returns an Application object that represents the creator of the specified object (you can use this property with an OLE Automation object to return the application of that object). Read-only.
Bb225711.properties(en-us,office.12).gif Borders Returns a Borders collection that represents the borders of a style or a range of cells (including a range defined as part of a conditional format).
Bb225711.properties(en-us,office.12).gif BuiltIn Read-only
Bb225711.properties(en-us,office.12).gif Font Returns a Font object that represents the font of the specified object.
Bb225711.properties(en-us,office.12).gif FormulaHidden Returns or sets a Boolean value that indicates if the formula will be hidden when the worksheet is protected.
Bb225711.properties(en-us,office.12).gif HorizontalAlignment Returns or sets a XlHAlign value that represents the horizontal alignment for the specified object.
Bb225711.properties(en-us,office.12).gif IncludeAlignment True if the style includes the AddIndent, HorizontalAlignment, VerticalAlignment, WrapText, IndentLevel, and Orientation properties. Read/write Boolean.
Bb225711.properties(en-us,office.12).gif IncludeBorder True if the style includes the Color, ColorIndex, LineStyle, and Weight border properties. Read/write Boolean.
Bb225711.properties(en-us,office.12).gif IncludeFont True if the style includes the Background, Bold, Color, ColorIndex, FontStyle, Italic, Name, Size, Strikethrough, Subscript, Superscript, and Underline font properties. Read/write Boolean.
Bb225711.properties(en-us,office.12).gif IncludeNumber True if the style includes the NumberFormat property. Read/write Boolean
Bb225711.properties(en-us,office.12).gif IncludePatterns True if the style includes the Color, ColorIndex, InvertIfNegative, Pattern, PatternColor, and PatternColorIndex interior properties. Read/write Boolean.
Bb225711.properties(en-us,office.12).gif IncludeProtection True if the style includes the FormulaHidden and Locked protection properties. Read/write Boolean.
Bb225711.properties(en-us,office.12).gif IndentLevel Returns or sets a Long value that represents the indent level for the style.
Bb225711.properties(en-us,office.12).gif Interior Returns an Interior object that represents the interior of the specified object.
Bb225711.properties(en-us,office.12).gif Locked Returns or sets a Boolean value that indicates if the object is locked.
Bb225711.properties(en-us,office.12).gif MergeCells True if the style contains merged cells. Read/write Variant.
Bb225711.properties(en-us,office.12).gif Name Returns a String value that represents the name of the object.
Bb225711.properties(en-us,office.12).gif NameLocal Returns or sets the name of the object, in the language of the user. Read-only String.
Bb225711.properties(en-us,office.12).gif NumberFormat Returns or sets a String value that represents the format code for the object.
Bb225711.properties(en-us,office.12).gif NumberFormatLocal Returns or sets a String value that represents the format code for the object as a string in the language of the user.
Bb225711.properties(en-us,office.12).gif Orientation Returns or sets a XlOrientation value that represents the text orientation.
Bb225711.properties(en-us,office.12).gif Parent Returns the parent object for the specified object. Read-only.
Bb225711.properties(en-us,office.12).gif ReadingOrder Returns or sets the reading order for the specified object. Can be one of the following constants: xlRTL (right-to-left), xlLTR (left-to-right), or xlContext. Read/write Long.
Bb225711.properties(en-us,office.12).gif ShrinkToFit Returns or sets a Boolean value that indicates if text automatically shrinks to fit in the available column width.
Bb225711.properties(en-us,office.12).gif Value Returns a String value that represents the name of the specified style.
Bb225711.properties(en-us,office.12).gif VerticalAlignment Returns or sets a XlVAlign value that represents the vertical alignment of the specified object.
Bb225711.properties(en-us,office.12).gif WrapText Returns or sets a Boolean value that indicates if Microsoft Excel wraps the text in the object.