Cell Format Properties

Name

Returns

Description

AddIndent

Variant

Set/Get whether the text in a cell is automatically indented when the text alignment is set to equal distribution, either horizontally or vertically

Borders

Borders

Set/Get the search criteria based on the cell's border format

Name

Returns

Description

Font

Font

Set/Get the search criteria based on the cell's font format

Formula Hidden

Variant

Set/Get whether the formula will be hidden when the worksheet is protected. Returns Null if the specified range contains some cells with hidden formulas and some cells without

Horizontal Alignment

Variant

Set/Get the horizontal alignment for the specified object

IndentLevel

Variant

Set/Get the indent level for the cell or range

Interior

Interior

Set/Get the search criteria based on the cell's interior format

Locked

Variant

Set/Get whether cells in the range can be modified if the sheet is protected. Returns Null if only some of the cells in the range are locked

MergeCells

Variant

Returns True if the range or style contains merged cells

NumberFormat

Variant

Set/Get the number format associated with the cells in the range. Null if all the cells don't have the same format

NumberFormat Local

Variant

Set/Get the number format associated with the cells in the range, in the language of the end user. Null if all the cells don't have the same format

Orientation

Variant

Set/Get the text orientation for the cell text. A value from -90 to 90 degrees can be specified, or use an XlOrientation constant

ShrinkToFit

Variant

Set/Get whether the cell text will automatically shrink to fit the column width. Returns Null if the rows in the range have different ShrinkToFit properties

Vertical Alignment

Variant

Set/Get how the cells in the range are vertically aligned. Use the XLVAlign constants

WrapText

Variant

Set/Get whether cell text wraps in the cell. Returns Null if the cells in the range contain different text wrap properties

0 0

Post a comment