Set colA = Columns("A:A")
'colA.Select
Set Balise2 = colA.Find(What:="Restaurants", After:=ActiveCell, LookIn:=xlFormulas2, LookAt:=xlPart, _
SearchOrder:=xlByRows, SearchDirection:=xlNext, MatchCase:=False, SearchFormat:=False)
If Not Balise2 Is Nothing Then ActiveWorkbook.Names.Add Name:="Restaurants", RefersTo:=Balise2
Set Balise1 = colA.Find(What:="Mensuelles", After:=ActiveCell, LookIn:=xlFormulas2, LookAt:=xlPart, _
SearchOrder:=xlByRows, SearchDirection:=xlNext, MatchCase:=False, SearchFormat:=False)
If Not Balise1 Is Nothing Then ActiveWorkbook.Names.Add Name:="Mensuelles", RefersTo:=Balise1