DefaultFormat Property

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

Syntax

object.DefaultFormat

object.DefaultFormat =DefaultFormat

Example 1

This example demonstrates how to return the default cell color of a worksheet document.

Debug.Print Wks.DefaultFormat.Backcolor

Example 2

This example demonstrates how to set the default cell color of a worksheet document to green.

Wks.DefaultFormat.Backcolor = grfColorGreen

 

Used by: Worksheet object