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.
Comparison strategies used by xlCompare