Sub Essai()
Dim Lr As Long
Dim MyRange As Range
Lr = Range("B" & Rows.Count).End(xlUp).Row
' si la cellule B contient gestionnaire
Range("A1").Value = "=IF(ISNUMBER(SEARCH(""gestionnaire"",RC[1])),RC[1],"""")"
Range("A1").AutoFill Destination:=Range("A1:A" & Lr)
Set MyRange = Sheets("Essai").UsedRange.Find("Gestionnaire")
ActiveCell.Offset(4, 0).Select
End Sub