1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28
| Private Sub CommandButton1_Click()
Sub Absent_Feuille_Vente()
Dim PlageAchat As Range, PlageVente As Range
Dim Tablo1, Tablo2, Plag3 As Range
Dim A As Long, B As Integer, C As Long, D As Integer
'si 100 lignes de comparaison
Set PlageAchat = Sheets("achat").Range("A1:A100")
Set PlageVente = Sheets("vente").Range("A1:A100")
Set Plag3 = Sheets("vente").Range("B1") 'début de plage de réception des différences
'comparaison des plages
If PlageAchat.Rows.Count <> PlageVente.Rows.Count Then
MsgBox "Les plages à comparer ne sont pas identiques"
Exit Sub
End If
Range("B1:B100").ClearContents 'efface la plage de réception
Tablo1 = PlageAchat: Tablo2 = PlageVente: D = 1
Application.ScreenUpdating = False
For A = 1 To UBound(Tablo1, 1)
For B = 1 To UBound(Tablo1, 2)
If Tablo1(A, B) <> Tablo2(A, B) Then
C = C + 1
Plag3(C, D) = Tablo1(A, B)
End If
Next
Next
End Sub
End Sub |