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