Bonjour,
Je coince un peu sur le développement de mon code...
Est-il possible de compiler 2 conditions "IN" dans un code ?
Mon code actuel:
Sub Connexion()
Dim Musine
Dim Mdate
Dim Ws1, Ws2 As Worksheet
Dim C
Dim D
Dim Li As Integer
Set Ws1 = Sheets("Suivi des gains"): Set Ws2 = Sheets("Connexion")
Ws1.[A19:E35].ClearContents
Musine = Ws1.[E10]
Mdate = Ws1.[E11]
Li = 19
For Each C In Ws2.Range("usines")
If UCase(C) = UCase([Musine]) And Ws2.Cells(C.Row, 6).Value = UCase("P") Then
Ws1.Cells(Li, 1) = Ws2.Cells(C.Row, 4).Value
Ws1.Cells(Li, 2) = Ws2.Cells(C.Row, 21).Value
Ws1.Cells(Li, 3) = Ws2.Cells(C.Row, 2).Value
Ws1.Cells(Li, 4) = Ws2.Cells(C.Row, 3).Value
Ws1.Cells(Li, 5) = Ws2.Cells(C.Row, 7).Value
Li = Li + 1
End If
Next
For Each D In Ws2.Range("Année_Investissement")
If UCase(D) = UCase([Mdate]) And Ws2.Cells(D.Row, 6).Value = UCase("P") Then
Ws1.Cells(Li, 1) = Ws2.Cells(D.Row, 4).Value
Ws1.Cells(Li, 2) = Ws2.Cells(D.Row, 21).Value
Ws1.Cells(Li, 3) = Ws2.Cells(D.Row, 2).Value
Ws1.Cells(Li, 4) = Ws2.Cells(D.Row, 3).Value
Ws1.Cells(Li, 5) = Ws2.Cells(D.Row, 7).Value
Li = Li + 1
End If
Next
End Sub
Avec ce code quand la deuxième boucle est activé, la première n'est plus prise en compte. Il me faut compiler les 2 conditions.
Merci d'avance.