With Target
If .Row >=5 and .Row <=120
.EntireRow.Interior.ColorIndex = 7
End If
End With
Private Sub Worksheet_SelectionChange(ByVal Target As Range)Bonjour MICHAEL
peut être ainsi(Non testé pas de Fichier)
Bonne JournéeCode:With Target If .Row >=5 and .Row <=120 .EntireRow.Interior.ColorIndex = 7 End If End With
Jean marie
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Cells.Interior.ColorIndex = 0
'Ici Le Code
With Target
If .Row >=5 And .Row <=120
.EntireRow.Interior.ColorIndex = 7
End If
End With
End Sub
Private Sub Worksheet_SelectionChange(ByVal Target As Range)Private Sub Worksheet_SelectionChange(ByVal Target As Range) Cells.Interior.ColorIndex = 0 'Ici Le Code With Target If .Row >=5 And .Row <=120 .EntireRow.Interior.ColorIndex = 7 End If End With End Sub
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Cells.Interior.ColorIndex = 0
With Target
If .Row >=5 And .Row <=120 Then '<---- Ici
.EntireRow.Interior.ColorIndex = 7
End If
End With
End Sub