Bonjour
avec Vba tu peux contourner cette limite en utilisant l'instruction select case ci joint un exemple que tu peux adapter
Bon courage
Public Sub periodicite() 'COLONNE PERIODICITE DANS FEUIL1
Application.ScreenUpdating = False
Feuil5.Activate
Dim taux As String, lastrow&,Z&, target
Cells(2, 14).Activate 'POSITIONNEMENT INITIAL COLONNE TAUX_1
Z = 0
Do Until Z = Lastrow - 1
taux = ActiveCell.Value
Select Case taux
Case Is = vbNullString
Target.Offset(Z, 2).Value = 1
Case Is = "TAM"
Target.Offset(Z, 2).Value = 1
Case Is = "PIBFRF3"
Target.Offset(Z, 2).Value = 3
Case Is = "EURIBOR3"
Target.Offset(Z, 2).Value = 3
Case Is = "EURIBOR6"
Target.Offset(Z, 2).Value = 3
Case Is = "EUR3_237"
Target.Offset(Z, 2).Value = 3
Case Is = "TAGEURO"
Target.Offset(Z, 2).Value = 1
Case Is = "OIS_EONIA"
Target.Offset(Z, 2).Value = 1
Case Else
End Select
Z = Z + 1
Cells(2 + Z, 14).Activate
Loop
End Sub