Sub test()
Dim ville(1), commune(1)
indextab = 2
nbrecolonneTCD = 5 ' nombre de colonnes de la ligne à scruter
ville(0) = "toulon"
Set found = Cells(2, indextab).Resize(, 1 + nbrecolonneTCD - indextab).Find(ville(0))
If found Is Nothing Then
MsgBox ville(0) & " non trouvée"
Else
commune(0) = ville(0)
MsgBox ville(0) & " en " & found.Address & vbLf & "commune=" & commune(0)
End If
End Sub