Share via


Window.DisplayZeros Property (Excel)

True if zero values are displayed. Read/write Boolean.

Syntax

expression .DisplayZeros

expression A variable that represents a Window object.

Remarks

This property applies only to worksheets and macro sheets.

Example

This example sets the active window in Book1.xls to display zero values.

Workbooks("BOOK1.XLS").Worksheets("Sheet1").Activate 
ActiveWindow.DisplayZeros = True 

See Also

Concepts

Window Object Members

Window Object