Comment puis-je conserver une mise en forme conditionnele lors d'une applic=
ation d'un filtre =C3=A9labor=C3=A9 ?
'----------
Private Sub Worksheet_Activate()
[T2] =3D "En attente"
derlig =3D Sheets("Feuil1").[A1].End(xlDown).Row
With Sheets("Feuil1")
.Range("A1:J" & derlig).AdvancedFilter Action:=3DxlFilterCopy, _
CriteriaRange:=3D.[T1:T2], _
CopyToRange:=3D[A1:J1], Uniq=
ue:=3DTrue
End With
End Sub
'----------
'--------------
Private Sub Worksheet_Activate()
Dim Derlig As Byte
Application.ScreenUpdating = False
Application.EnableEvents = False
ActiveSheet.Cells.Delete
With Sheets("Feuil1")
.[T2] = "En cours"
Derlig = .[A1].End(xlDown).Row
.Range("A1:C" & Derlig).AdvancedFilter Action:=xlFilterInPlace, _
CriteriaRange:=.[T1:T2], _
Unique:=True
.Range("A1:C" & Derlig).SpecialCells(xlCellTypeVisible).Copy
End With
ActiveSheet.Paste
Application.CutCopyMode = False
Sheets("Feuil1").AutoFilterMode = False
Application.ScreenUpdating = True
Application.EnableEvents = True
End Sub
'--------------