Sub Majuscules()
Dim h&, tablo, ub As Byte, i&, j As Byte
h = [A65536].End(xlUp).Row - 1
If h = 0 Then Exit Sub
tablo = [A2:G2].Resize(h) 'matrice => exécution plus rapide
ub = UBound(tablo, 2)
For i = 1 To UBound(tablo)
For j = 1 To ub
If j <> 4 And j <> 7 Then tablo(i, j) = UCase(tablo(i, j))
Next
Next
Application.EnableEvents = False 'désactive l'action des événements
[A2:G2].Resize(h) = tablo
Application.EnableEvents = True
End Sub