Dim OldLine As Range
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
'
Dim MaPlage As Range
Set MaPlage = ActiveSheet.Range("B2:G15")
If Target.Rows.Count = 1 Then
If Not OldLine Is Nothing Then
With MaPlage.Resize(1).Offset(OldLine.Row - 2).Interior
.Pattern = xlSolid
.PatternColorIndex = xlAutomatic
.PatternTintAndShade = 0
End With
End If
If Not Intersect(Target, MaPlage) Is Nothing Then
With MaPlage.Resize(1).Offset(Target.Row - 2).Interior
.Pattern = xlLightUp...