Sub cherhchebas()
On Error Resume Next
ActiveSheet.Range("A:A").Find(What:="DEP", After:=Cells(ActiveCell.Row, 1), LookIn:=xlFormulas, _
LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, _
MatchCase:=False, SearchFormat:=False).Activate
On Error GoTo 0
End Sub
Sub cherhchehaut()
On Error Resume Next
ActiveSheet.Range("A:A").Find(What:="DEP", After:=Cells(ActiveCell.Row, 1), LookIn:=xlFormulas, _
LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlPrevious, _
MatchCase:=False, SearchFormat:=False).Activate
On Error GoTo 0
End Sub