merge and compare workbooks button not functioning

[Tracy]

I am trying to do a comparison between an original workbook with a workbook
created from the original which has had changes made to it. I used the help
file to add this button to the quick access toolbar. However, I can not make
the button work. I have the workbook open as I was told do in the help menu
but the button is "greyed" out (the way options normally appear on drop down
menus when you can't use a feature for whatever reason). Any suggestions??

 

[ryguy7272]

I use code like this to compare values on two sheets:
Sub Compare2Shts()
For Each Cell In Worksheets("CompareSheet#1").UsedRange
If Cell.Value <> Worksheets("CompareSheet#2").Range(Cell.Address) Then
Cell.Interior.ColorIndex = 3
End If
Next

For Each Cell In Worksheets("CompareSheet#2").UsedRange
If Cell.Value <> Worksheets("CompareSheet#1").Range(Cell.Address) Then
Cell.Interior.ColorIndex = 3
End If
Next
End Sub

Regards,
Ryan--

 

[Gord Dibben]

Merge and Compare can only be used different versions of Shared Workbooks.

Cannot be used as you desire.


Gord Dibben MS Excel MVP