[COLOR="DarkSlateGray"][B]Sub toto()
Dim odat(), i As Long, titre As String
Application.ScreenUpdating = False
odat = Cells(1, 1).CurrentRegion.Value
For i = 2 To UBound(odat, 1)
If IsEmpty(odat(i, 1)) Then
odat(i, 1) = titre
Else
titre = odat(i, 1)
End If
Next i
Cells(1, 1).CurrentRegion.Value = odat
For i = UBound(odat, 1) To 2 Step -1
If Cells(i, 2).Value = "Processus" Then Rows(i).Delete Shift:=xlUp
Next i
Application.ScreenUpdating = True
End Sub[/B][/COLOR]