xlCompare opens your workbook in the Manual Calculation Mode. Data is not recalculated after the every change in the cell.
Use should use this command to recalculate the workbook and see the result of your changes.