Sub BD2_BD1()
Set f1 = Sheets("Base1")
Set f2 = Sheets("Base2")
Set MonDico1 = CreateObject("Scripting.Dictionary")
For Each c In f1.Range("a2:a" & f1.[a65000].End(xlUp).Row)
MonDico1.Item(c.Value) = c.Value
Next c
Set MonDico2 = CreateObject("Scripting.Dictionary")
For Each c In f2.Range("a2:a" & f2.[b65000].End(xlUp).Row)
If Not MonDico1.exists(c.Value) Then
If Not MonDico2.exists(c.Value) Then MonDico2.Add c.Value, c.Row
End If
Next c
Sheets("Différences dans la Base2").[A2].Resize(MonDico2.Count, 1) = Application.Transpose(MonDico2.keys)
Sheets("Différences dans la Base2").[b2].Resize(MonDico2.Count, 1) = Application.Transpose(MonDico2.items)
End Sub