Re, et Bonjour Amadeus,
Hormis le souci de ta demande, ton code pourrait, si je me trompe, se résumer à ceci :
Private Sub Worksheet_Change(ByVal Target As Range)
Select Case UCase(Target)
Case "CO", "PARC ST JEAN": i = 4
Case "GYM", "CIRg", "LUTg": i = 6
Case "HB", "JPS", "COUR COLLEGE": i = 7
Case "FB", "RY", "THEQ", "LAN", "TERRAIN FOOT": i = 10
Case "V", "PISTE": i = 17
Case "CDD", "MAIN COURANTE": i = 31
Case "NATb", "SAUVb", "PIS BABYLONE": i = 33
Case "BADv", "HAUv", "VBv", "BBv", "HBv", "JPSv", "VENDEMIERE": i = 36
Case "SAUVt", "NATt", "PISCINE TRIOLO": i = 37
Case "TEN", "SALLE 8 MAI": i = 38
Case "CIR", "TT", "LUT", "HAUa", "LUTa", "AGORA": i = 39
Case "SYNTHETIQUE", "FBs", "THEQs": i = 40
Case "ESC", "TAMISE": i = 43
Case "BAD", "HAU", "VB", "BB", "CIRs", "LUTs", "2/3 SALLE": i = 45
Case "HVC", "CoEPS", "ConsCOL": i = 48
Case "BLO", "BLOC": i = 50
Case Else
i = 2
End Select
Target.Interior.ColorIndex = i
End sub
Amicalement