Settings.Outline Property

<< Click to Display Table of Contents >>

Navigation:  Developer Edition > Visual Basic for Applications (VBA) > Object Model Reference > Settings Object > Properties >

Settings.Outline Property

Previous pageReturn to chapter overviewNext page

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




expression. A variable representing a Settings object.



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



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


With .Settings

  .Outline = OutlineFlag_Enabled + _

             OutlineFlag_DifferentRows + OutlineFlag_MissingRows + OutlineFlag_DuplicateRows + _


End With