<< Click to Display Table of Contents >> Settings.FilterTolerance Property |
Returns or sets a number below which numeric differences will be ignored. Double value.
expression.FilterTolerance
expression. A variable representing a Settings object.
With .Settings
.Filters = FilterFlag_Enabled
.FilterTolerance = 0.01
End With
This example will filter out any results where numeric differences are less than or equal to 1 percent of the source cell's value (e.g. 100 vs 99, but not 99 vs 100):
With .Settings
.Filters = FilterFlag_Enabled + FilterFlag_RelativeTolerance
.FilterTolerance = 0.01
End With