Format Property

Format returns the CellFormat object used by the cells in the range. Returns aWksCellFormat object. This is a read-only property.

Syntax

object.Format

Example 1

This example demonstrates how to return the numeric format of a range of cells.

Debug.Print WksRange.Format.NumericType

Example 2

This example demonstrates how to set the cell color of a range to chalk.

WksRange.Format.BackColor = wksColorChalk

Used by: WksRange object