We suggest you to review the topics below. Possible you'll find answer to your questions about xlCompare
We've created a F.A.Q
section on our website. It contains answers to the most common questions
we receive. In this section you'll also find a useful information for you. Go to the F.A.Q. topic
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.