The Format property returns the WksCellFormat object used by the cells in the range. 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 = mvColorChalk
Used by: WksRange object