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 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57
| Private Sub dezr()
Dim Plage As Range, Cellules As Range, Cellules1 As Range
Dim bytMois As Byte
Dim intAnnee As Integer
Dim recup As String
With Worksheets("Feuil1")
For Each Cellules1 In Worksheets("Feuil1").Range("K4:k" & .Range("k" & .Rows.Count).End(xlUp).Row)
Set Plage = Nothing
For Each Cellules In Worksheets("Feuil1").Range("B4:b" & .Range("b" & .Rows.Count).End(xlUp).Row)
If Cellules = Cellules1 And Cellules(1, 2) = "Martin" Then
If Plage Is Nothing Then
Set Plage = Cellules
Else
Set Plage = Union(Plage, Cellules)
End If
recup = Cellules.Value
End If
Next Cellules
If Not Plage Is Nothing Then
If Plage.Count < 2 Then
Application.CutCopyMode = True
Plage.Copy
With Worksheets("Feuil3")
Worksheets("Feuil3").Select
ActiveSheet.UsedRange.Cells(ActiveSheet.UsedRange.Rows.Count + 1, ActiveSheet.UsedRange.Columns.Count).Select
ActiveSheet.Paste
Application.CutCopyMode = False
End With
Else
With Worksheets("Feuil3")
Worksheets("Feuil3").Select
Application.CutCopyMode = True
Plage.Copy
ActiveSheet.UsedRange.Cells(ActiveSheet.UsedRange.Rows.Count + 1, ActiveSheet.UsedRange.Columns.Count).Select
ActiveSheet.Paste
Application.CutCopyMode = False
ActiveSheet.UsedRange.Cells(ActiveSheet.UsedRange.Rows.Count + 1, ActiveSheet.UsedRange.Columns.Count).Value = recup
End With
End If
End If
Next Cellules1
End With
End Sub |
Partager