Writing Excel Macros with VBA, 2nd Edition

Name

CellFormat Object

Synopsis

Path: Application - CellFormat

Object	Methods	Properties
CellFormat	Clear( )	AddIndent( ) As Variant Borders( ) As Borders Font( ) As Font FormulaHidden( ) As Variant HorizontalAlignment( ) As Variant IndentLevel( ) As Variant Interior( ) As Interior Locked( ) As Variant MergeCells( ) As Variant NumberFormat( ) As Variant NumberFormatLocal( ) As Variant Orientation( ) As Variant ShrinkToFit( ) As Variant VerticalAlignment( ) As Variant WrapText( ) As Variant

The CellFormat object works in conjunction with the FindFormat and ReplaceFormat objects to programmatically find and replace cell formatting. For more on this, please see Chapter 16.