Private Sub worksheet_Change(ByVal Target As Range)
If Not Intersect(Target, Range("C1:C41")) Is Nothing And Target.Value = "essai" Then
Range("A" & Target.Row + 1 & ":A" & Target.Row + 47).EntireRow.Hidden = False
Else
Range("A" & Target.Row + 1 & ":A" & Target.Row + 47).EntireRow.Hidden = True
End If
End Sub