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