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
|
Private Sub Triage(NomFeuille As String)
Dim TopDebrayeN As String
Dim TopRQIN As String
Dim Test As Integer
i = 3
TopDebrayeN = "N"
TopRQIN = "IN"
Workbooks(ClasseurEMI).Sheets(NomFeuille).Activate
Do While Not IsEmpty(Cells(i, 1)) Or i = 65536
Test = 0
TestDebraye = InStr(Cells(i, 47), TopDebrayeN)
TestTopRQ = InStr(Cells(i, 46), TopRQIN)
If TestDebraye <> 0 And TestTopRQ <> 0 Then
'Procédure de copie du classeur ARRIERE EMI vers le classeur OUTIL HD
ProcCopie i, NomFeuille, OuColler
OuColler = OuColler + 1
End If
i = i + 1
Loop
End Sub |