01. Sub comparer1() 02. Dim i As Long, j As Long 03. Dim nbl As Long 04. nbl = Range("a65536").End(xlUp).Row 05. For i = 1 To nbl 06. If Workbooks("classeur11.xls").Worksheets("feuil1").Range("a" & i).Value & Range("b" & i).Value <> Workbooks("classeur2a.xls").Worksheets("feuil1").Range("c" & i).Value & Range("b" & i).Value Then 07. Workbooks("classeur11.xls").Worksheets("feuil1").Range("b" & i).Interior.Color = RGB(255, 234, 102) 08. End If 09. Next i 10. End Sub
Sub comparer1() Dim i As Long Dim j As Long Dim Feuil1 As Worksheet Dim Feuil2 As Worksheet Set Feuil1 = Workbooks("classeur11.xls").Worksheets("feuil1") Set Feuil2 = Workbooks("classeur2a.xls").Worksheets("feuil1") For i = 1 To Feuil1.Range("A65536").End(xlUp).Row If Feuil1.Range("A" & i).Value & Feuil1.Range("B" & i).Value <> Feuil2.Range("A" & i).Value & Feuil2.Range("B" & i).Value Then Feuil1.Range("B" & i).Interior.Color = RGB(255, 234, 102) End If Next i Set Feuil1 = Nothing Set Feuil2 = Nothing End Sub
Vous n’avez pas trouvé la réponse que vous recherchez ?
Posez votre question