Returns or sets a number below which numeric differences will be ignored. Double value.

Syntax

expression.FilterTolerance

expression. A variable representing a Settings object.

Example 1
This example will filter out any results where numeric differences are less than or equal to 0.01 (e.g. 0.01 vs .015):

With .Settings

  .Filters = FilterFlag_Enabled

  .FilterTolerance = 0.01

End With

 
 
Example 2

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