nbreligne = WorksheetFunction.CountA(Columns(3))
For indextab = 2 To nbreligne Step 1
If InStr(Cells(indextab, 8).Value, "Tadao") <> 0 Then
Cells(indextab, 7).Value = "Exploitation"
ElseIf InStr(Cells(indextab, 8).Value, "") <> 0 Or InStr(Cells(indextab, 8).Value, "Aucun") <> 0 Then
If InStr(Cells(indextab, 12).Value, "Boutique") <> 0 Then
Cells(indextab, 7).Value = "Boutique"
Else
Cells(indextab, 7).Value = "Autre"
End If
ElseIf InStr(Cells(indextab, 8).Value, "Tadao") <> 1 And InStr(Cells(indextab, 8).Value, "") <> 1 And InStr(Cells(indextab, 8).Value, "Aucun") <> 1 Then
Cells(indextab, 7).Value = "Affrétés"
Next indextab