Compare | Sheets menu command
Use this command to compare 2 worksheets.
This command is similar to Compare | Books command. But it compares 2 worksheets, which are selected in the xlCompare
left and right panes.
Use this command when you want to compare worksheets with different names, or when you are comparing sheets in the same book.
xlCompare compares all worksheets with same names in the opened books. After comparison you get Difference Browser
window. It displays comparison results.