Dim Derlig&
Set ws = ThisWorkbook.Sheets.Add(After:=ThisWorkbook.Sheets(ThisWorkbook.Sheets.Count))
ws.Name = "supérieurs à 5%"
With Sheets("RESULTATS")
Derlig = .Range("A" & Rows.Count).End(xlUp).Row
.Range("A1:AQ" & Derlig).SpecialCells(xlCellTypeVisible).Copy Destination:=Sheets(" supérieurs à 5%").Range("A1")
End With