Share via

Window.DisplayZeros Property

  • Article
Excel Developer Reference

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.

Visual Basic for Applications 
  Workbooks("BOOK1.XLS").Worksheets("Sheet1").Activate
ActiveWindow.DisplayZeros = True

See Also