FilterFlag Enumeration

<< Click to Display Table of Contents >>

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

FilterFlag Enumeration

Previous pageReturn to chapter overviewNext page

Constants used to by the Filters property in Settings.

 

Name

Description

FilterFlag_Constants

All constants are ignored. Only formulas are compared.

FilterFlag_Datatype

Differences in datatype are ignored. Use to ignore differences between date

values and string values representing dates.

FilterFlag_Enabled

Enable or disable all other filters options.

FilterFlag_Formulas

All formulas are ignored. Only constants are compared.

FilterFlag_HiddenCols

Data in hidden columns will be ignored.

FilterFlag_HiddenRows

Data in hidden rows will be ignored.

FilterFlag_None

No filters will be used.

FilterFlag_SameValues

Different cell values/formulas with same result will be ignored.

FilterFlag_StringCase

Text compare case Insensitive. "ABC" vs "abc" will be considered as equal.

FilterFlag_StringSpace

Text compare trim text. "ABC " vs "ABC" will be considered as equal.

FilterFlag_RelativeTolerance

If this flag is on, then the relative differences (%) are filtered out (instead of numeric differences #)