Dim cellA As Range Dim cellB As Range Set cellA = Worksheets("Feuil1").Range("A1") Set cellB = Worksheets("Feuil2").Range("A1") While Not (IsEmpty(cellA) And IsEmpty(cellB)) If StrComp(cellA, cellB) <> 0 Then Rows(cellA.Row).Insert Set cellA = cellA.Offset(-1, 0) cellA.Value = cellB.Value End If Set cellA = cellA.Offset(1, 0) Set cellB = cellB.Offset(1, 0) Wend
Vous n’avez pas trouvé la réponse que vous recherchez ?
Posez votre questionIf StrComp(cellA, cellB) <> 0 Then Rows(cellA.Row).Insert Set cellA = cellA.Offset(-1, 0) cellA. FormulaR1C1 = cellB.FormulaR1C1 End If