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