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
| Worksheets("feuil1").Select
For i = LignDepFeuil1 To LignFinFeuil1
Cells(i, 8).FormulaR1C1 = _
"=VLOOKUP(RC[-1],'Feuil1'!R1C1:R36C1,1,FALSE)"
Next i
For i = LignDepFeuil1 To LignFinFeuil1
Cells(i, 9).FormulaR1C1 = "=ISNA(RC[-1])"
Next i
For i = LignDepFeuil1 To LignFinFeuil1
Cells(i, 9).FormulaR1C1 = Trim(Cells(i, 9))
Next i
Range("A2:I2").Select
Range(Selection, Selection.End(xlDown)).Select
Selection.Sort Key1:=Range("H1"), Order1:=xlAscending, Header:=xlGuess, _
OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, _
DataOption1:=xlSortNormal
derniereLigne = ActiveSheet.UsedRange.Rows.Count
'Application.ScreenUpdating = False
For r = derniereLigne To 1 Step -1
If (Range("I" & r)) = "Vrai" Then Rows(r).Delete
Next r |
Partager