Settings.Filters Property

<< Click to Display Table of Contents >>

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

Settings.Filters Property

Previous pageReturn to chapter overviewNext page

Returns or sets a series of options specifying which differences to filter (ignore). FiltersFlag constant.

 

Syntax

expression.Filters

expression. A variable representing a Settings object.

 

Remarks

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

 

Example

This example compares the worksheets using filters.

 

With .Settings

  .Filters = FilterFlag_Enabled + FilterFlag_StringCase + FilterFlag_StringSpace

  .FilterTolerance = 0.01

  .FilterEquivalents = "yes,ja;no,nein"

End With