Option Explicit
Sub Supprimer_v2()
Dim o As Object
Application.ScreenUpdating = False
If ActiveSheet.Name <> "PLANNING HOMME FEMME" Then Exit Sub
Range("b6:l65000").AutoFilter Field:=1, Criteria1:=RGB(255, 0 _
, 0), Operator:=xlFilterCellColor
Rows("7:" & Rows.Count).SpecialCells(xlCellTypeVisible).EntireRow.Delete
Range("b6:l65000").AutoFilter Field:=1
If Range("h2").Value = "PLANNING ROULAGE PROJET H/F" Then
For Each o In Worksheets(Array("SEMESTRE 1", "SEMESTRE 2"))
On Error Resume Next
o.Activate
With o
.Cells.Find(What:="PERSONNEL FEMININ", After:=ActiveCell, LookIn:=xlValues _
, LookAt:=xlWhole, SearchOrder:=xlByRows, SearchDirection:=xlNext, _
MatchCase:=False, SearchFormat:=False).Resize(, 256).Select
With Selection: .UnMerge: .Delete Shift:=xlUp: End With
.Range("a1").Select
End With
Next
Sheets("PLANNING HOMME FEMME").Activate
Range("h2").Value = "PLANNING HOMMES"
Exit Sub
End If
Application.ScreenUpdating = True
End Sub