DisplayZeros Property Example
This example sets the active window in Book1.xls to display zero values.
Workbooks("BOOK1.XLS").Worksheets("Sheet1").Activate ActiveWindow.DisplayZeros = True