DisplayFormat object (Excel)

Represents the display settings for an associated Range object. Read-only.

Remarks

Actions such as changing the conditional formatting or table style of a range can cause what is displayed in the current user interface to be inconsistent with the values in the corresponding properties of the Range object. Use the properties of the DisplayFormat object to return the values as they are displayed in the current user interface.

Properties

• AddIndent
• Application
• Borders
• Characters
• Creator
• Font
• FormulaHidden
• HorizontalAlignment
• IndentLevel
• Interior
• Locked
• MergeCells
• NumberFormat
• NumberFormatLocal
• Orientation
• Parent
• ReadingOrder
• ShrinkToFit
• Style
• VerticalAlignment
• WrapText

See also

• Excel Object Model Reference

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.