Dim Ref As String Dim Code As String Dim Resultat As String Ref = "A 055 URD 32 LI 1600" For i = 0 To Ref.Length - 2 Code = Ref.Substring(i, 2) If Code "32" Or Code "73" Then 'Compléter les OR Resultat = Ref Exit For End If Next
For i = 0 To Ref.Length - 2
Code = Ref.Substring(i, 2)
For i = 0 To Len(Ref)- 2
Code = Mid$(Ref, i, 2)
Vous n’avez pas trouvé la réponse que vous recherchez ?
Posez votre questionDim Ref As String Dim Code As String Dim Resultat As String Dim fin As Long Ref = ActiveSheet.Cells(1, 1) fin = Len(Ref) - 1 For i = 1 To fin Code = Mid(Ref, i, 2) Select Case Code Case 32, 73 Resultat = Ref Exit For End Select Next i