Returns or sets a series of options specifying which group of Rows and Columns to Show or Hide. Uses OutlineFlag constants.

Syntax

expression.Outline

expression. A variable representing a Settings object.

Remarks

If the ENABLED flag is not set, all other flags are ignored.

Example

This example shows only the differences. Identical rows are hidden.

With .Settings

  .Outline = OutlineFlag_Enabled + _

             OutlineFlag_DifferentRows + OutlineFlag_MissingRows + OutlineFlag_DuplicateRows + _

             OutlineFlag_MissingCols

End With