CellFormat Object Members

  • Article
Excel Developer Reference

Represents the search criteria for the cell format.

Methods

  Name Description
Bb255878.methods(en-us,office.12).gif Clear Clears the criterias set in the FindFormat and ReplaceFormat properties.

Properties

  Name Description
Bb255878.properties(en-us,office.12).gif AddIndent Returns or sets a Variant value that indicates if text is automatically indented when the text alignment in a cell is set to equal distribution (either horizontally or vertically.)
Bb255878.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.
Bb255878.properties(en-us,office.12).gif Borders Returns or sets a Borders collection that represents the search criteria based on the cell's border format.
Bb255878.properties(en-us,office.12).gif Font Returns a Font object, allowing the user to set or return the search criteria based on the cell's font format.
Bb255878.properties(en-us,office.12).gif FormulaHidden Returns or sets a Variant value that indicates if the formula will be hidden when the worksheet is protected.
Bb255878.properties(en-us,office.12).gif HorizontalAlignment Returns or sets a Variant value that represents the horizontal alignment for the specified object.
Bb255878.properties(en-us,office.12).gif IndentLevel Returns or sets a Variant value that represents the indent level for the cell or range. Can be an integer from 0 to 15.
Bb255878.properties(en-us,office.12).gif Interior Returns an Interior object allowing the user to set or return the search criteria based on the cell's interior format.
Bb255878.properties(en-us,office.12).gif Locked Returns or sets a Variant value that indicates if the object is locked.
Bb255878.properties(en-us,office.12).gif MergeCells True if the range or style contains merged cells. Read/write Variant.
Bb255878.properties(en-us,office.12).gif NumberFormat Returns or sets a Variant value that represents the format code for the object.
Bb255878.properties(en-us,office.12).gif NumberFormatLocal Returns or sets a Variant value that represents the format code for the object as a string in the language of the user.
Bb255878.properties(en-us,office.12).gif Orientation Returns or sets a Variant value that represents the text orientation.
Bb255878.properties(en-us,office.12).gif Parent Returns the parent object for the specified object. Read-only.
Bb255878.properties(en-us,office.12).gif ShrinkToFit Returns or sets a Variant value that indicates.
Bb255878.properties(en-us,office.12).gif VerticalAlignment Returns or sets a Variant value that represents the vertical alignment of the specified object.
Bb255878.properties(en-us,office.12).gif WrapText Returns or sets a Variant value that indicates if Microsoft Excel wraps the text in the object.