Sub comparaison()
Dim maPlage As Range
Dim DernLigne As Long
DernLigne = Range("A" & Rows.Count).End(xlUp).Row
Set maPlage = Range("A1:Z" & DernLigne)
Dim VALEURA As String, VALEURB As String
Dim DATEA As Date, DATEB As Date
DATEA = Format(DateSerial(Year(Date), Month(Date), Day(Date)), "dd/mm/yyyy")
DATEB = Format(DateSerial(Year(Date), Month(Date), Day(Date)), "dd/mm/yyyy")
For i = 3 To DernLigne
VALEURA = Range("A" & i).Value + Range("B" & i).Value
'DATEA = Range("D" & i).Value2
For j = 3 To DernLigne
VALEURB = Range("G" & j).Value '+ Range("H" & j).Value
'DATEB = Range("J" & j).Value2
If VALEURA = VALEURB Then
MsgBox ("liste 1, ligne " & i & " <=> et liste 2, ligne " & j & " sont identiques")
'Range("D" & i).Value = "oui"
'Cel.Offset("D" & i) = "Oui"
End If
Next j
Next i
End Sub