Settings.FilterEquivalents Property

<< Click to Display Table of Contents >>

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

Settings.FilterEquivalents Property

Previous pageReturn to chapter overviewNext page

Returns or sets the equivalent values. String value.

 

Syntax

expression.FilterEquivalents

expression. A variable representing a Settings object.

 

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