Public Plage
Sub MémorisePlage()
Plage = Sheets("Accueil").Range("B13:B40")
End Sub
Sub VérifPlage()
Application.EnableEvents = False
Calculate
For L = 13 To 40 Step 2
If Cells(L, "B") <> Plage(L - 12, 1) Then
Cells(L, "G") = "": Cells(L, "L") = ""
Plage(L - 12, 1) = Cells(L, "B")
End If
Next L
Application.EnableEvents = True
End Sub