1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19
| Sub Sup0Ja()
Application.ScreenUpdating = False
Application.EnableEvents = False
Dim plg As Range, x As Variant, i As Integer, y As Integer
Worksheets("BdD").Activate
ActiveSheet.ListObjects("BdD").Range.AutoFilter Field:=2, Criteria1:= _
"JA Yan"
Set plg = ActiveSheet.Range("_filterdatabase").SpecialCells(xlCellTypeVisible)
x = Split(plg.Address, ",")
For i = LBound(x) + 1 To UBound(x)
'je veux remplacer les formules par leur résultat dans la colonne BdD[Tp Post Traitm]
Range("BdD[Tp Post Traitm]").Copy
Range("BdD[Tp Post Traitm]").PasteSpecial Paste:=xlPasteValues 'C'est ici que ça ne fonctionne plus
Range("BdD[Tp Post Traitm]").Replace What:="00:00:00", Replacement:=""
Next i
Application.ScreenUpdating = True
Application.EnableEvents = True
End Sub |
Partager