DefaultFormat Property

DefaultFormat returns the default format object for the worksheet. Returns a WksCellFormat object. This is a read-only property.

Syntax

object.DefaultFormat

Example 1

This example demonstrates how to return the WksCellFormat object's default cell color (BackColor) of a worksheet document.

Debug.Print Wks.DefaultFormat.BackColor

Example 2

This example demonstrates how to set the WksCellFormat object's default cell color (BackColor) of a worksheet document to green.

Wks.DefaultFormat.BackColor = srfColorGreen

Used by: WksDocument object