1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19
| Sub CouleurModuleC()
Dim TabVal() As Variant
Dim TabCoul() As Variant
TabVal = Array("1:ROU", "2:BLF", "3:VER", "4:JAU", "5:VIO", "6:BLA", "7:ORA", "08:GRI", "19:MAR", "10:NOI", "11:BLC", "12:ROS", "09:MAR", "10:VEC")
TabCoul = Array(255, 12611584, 5287936, 65535, 10498160, -1, 49407, 12632256, 13209, 0, 16763904, 16711935, 13209, 65280)
With Worksheets("Feuil1")
For i = 1 To .UsedRange.Rows.Count
For j = LBound(TabVal) To UBound(TabVal)
If .Cells(i, 1) Like "*" & TabVal(j) & "*" Then
.Cells(i, 1).Resize(0,10).Interior.Color = TabCoul(j)
Exit For
End If
Next j
Next i
End With
End Sub |
Partager