Private Sub Worksheet_Activate()
Dim c As Range
For Each c In [D41:H41] 'plage à adapter
If c <> "" Then Rotation c, c(4) 'c <> "" si cellules fusionnées
Next
End Sub
Private Sub Worksheet_Change(ByVal Target As Range)
Dim c As Range
For Each c In [J41:K41] 'plage à adapter
If c <> "" Then Rotation c, c(4) 'c <> "" si cellules fusionnées
Next
End Sub