How can I compare cells from different excel files?
I've tried with this code with no success:
Sub test() Dim ULin As Long ULin = Range("A65536").End(xlUp).Row For i = 2 To ULin If Range("AE" & i).Value = Windows("CN.xls").Range("R" & i).Value Then Range("AF" & i) = "Ok" Else Range("AF" & i) = "Problem" End If Next End Sub