Compare | Options | Strict (Smart) menu commands

This is important group of commands which affects the comparison results.

xlCompare has 2 comparison strategies:

  • Strict: xlCompare thinks that if cells has different values or different formulas or different styles - they are different. So, if finds all possible differences in the worksheets.
  • Smart: If cells has equal formuals, they are considered as "equal", even if they have different values. If cells doesn't have formulas, xlCompare uses values for comparison.

Smart option allows you to find different input values in your worksheets. It shows source of the differences, rejecting mismatched cells based on the different inputs.

See Also:

Comparison strategies used by xlCompare