1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35
| Sub Repeat(NomFeuille As String)
Dim c As Range, Var1 As String, Var2 As String, Var3 As String
Worksheets(NomFeuille).Activate
With ActiveSheet.UsedRange
Set c = .Find("*|*|*", LookIn:=xlValues, lookat:=xlPart)
If Not c Is Nothing Then
Deb = c.Address
Do
Var1 = ""
Var2 = ""
Var3 = ""
Var1 = Mid(c, InStr(c, "|"), (Len(c) - InStr(c, "|")))
If InStr(Var1, "-") = 0 Then
Var2 = Mid(c, InStr(c, "|") + 1, (Len(c) - InStr(c, "|") - 2))
Range(c.Address) = Replace(c, Var1, "|" & Var2 & Var2 & "|")
Else
Var2 = Mid(c, InStr(c, "|") + 1, InStr(c, "-") - 2)
Var3 = Mid(c, InStrRev(c, "|") - 1, InStr(c, "-") - 2)
Range(c.Address) = Replace(c, Var1, "|" & Var2 & Var2 & "-" & Var3 & Var3 & "|")
End If
Range(c.Address).Activate
With ActiveCell
f = Len(.Value)
g = InStr(1, .Value, "(")
.Characters(Start:=g - 1, Length:=f - g + 2).Font.ColorIndex = 3
End With
Set c = .FindNext(c)
Loop While Not c Is Nothing And c.Address <> Deb
End If
End With
End Sub |
Partager