<< Click to Display Table of Contents >> Settings.Filters Property |
Returns or sets a series of options specifying which differences to filter (ignore). FiltersFlag constant.
expression.Filters
expression. A variable representing a Settings object.
If the ENABLED flag is not set, all other flags are ignored.
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