Format Property [WksRange]

The Format property returns the WksCellFormat object used by the cells in the range. This is a read-only property.

Syntax

object.Format

object.Format =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 = grfColorChalk

 

Used by: WksRange object