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 29 30 31 32 33 34 35 36 37 38
| Option Explicit
Sub Bouton1_Clic()
Dim E_F1 As Range
Dim CelluleF1 As Range
Dim DerniereLigneF1 As Long
Dim E_F2 As Range
Dim CelluleF2 As Range
Dim DerniereLigneF2 As Long
With Worksheets("Feuil1")
DerniereLigneF1 = .Cells(.Rows.Count, 5).End(xlUp).Row
Set E_F1 = .Range(.Cells(2, 5), .Cells(DerniereLigneF1, 5))
' MsgBox E_F1.Address
End With
With Worksheets("Feuil2")
DerniereLigneF2 = .Cells(.Rows.Count, 5).End(xlUp).Row
Set E_F2 = .Range(.Cells(2, 5), .Cells(DerniereLigneF2, 5))
' MsgBox E_F2.Address
End With
For Each CelluleF2 In E_F2
For Each CelluleF1 In E_F1
If CelluleF2 = CelluleF1 Then
Range(CelluleF2.Offset(0, -4), CelluleF2.Offset(0, -1)).Value = Range(CelluleF1.Offset(0, -4), CelluleF1.Offset(0, -1)).Value
Exit For
End If
Next CelluleF1
Next CelluleF2
Set E_F2 = Nothing
Set E_F1 = Nothing
End Sub |
Partager