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

 

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 = mvColorGreen

 

Used by: WksDocument object