Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic

CellFormat Members (Excel)

Represents the search criteria for the cell format.

Name

Description

Clear

Clears the criterias set in the FindFormat and ReplaceFormat properties.

Name

Description

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.)

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.

Borders

Returns or sets a Borders collection that represents the search criteria based on the cell's border format.

Creator

Returns a 32-bit integer that indicates the application in which this object was created. Read-only Long.

Font

Returns a Font object, allowing the user to set or return the search criteria based on the cell's font format.

FormulaHidden

Returns or sets a Variant value that indicates if the formula will be hidden when the worksheet is protected.

HorizontalAlignment

Returns or sets a Variant value that represents the horizontal alignment for the specified object.

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.

Interior

Returns an Interior object allowing the user to set or return the search criteria based on the cell's interior format.

Locked

Returns or sets a Variant value that indicates if the object is locked.

MergeCells

True if the range or style contains merged cells. Read/write Variant.

NumberFormat

Returns or sets a Variant value that represents the format code for the object.

NumberFormatLocal

Returns or sets a Variant value that represents the format code for the object as a string in the language of the user.

Orientation

Returns or sets a Variant value that represents the text orientation.

Parent

Returns the parent object for the specified object. Read-only.

ShrinkToFit

Returns or sets a Variant value that indicates.

VerticalAlignment

Returns or sets a Variant value that represents the vertical alignment of the specified object.

WrapText

Returns or sets a Variant value that indicates if Microsoft Excel wraps the text in the object.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.