Code : Sélectionner tout - Visualiser dans une fenêtre à part
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26 Private Sub Worksheet_Change(ByVal Target As Range) Dim c As Range On Error GoTo fin If Not Application.Intersect(Target, Range("E13:G13,E14:G14")) Is Nothing Then If Target.Value <> 0 Then For Each c In Range("E13:G13,E14:G14") If c.Address <> Target.Address And c.Row = Target.Row Then c.Value = 0 End If Next c End If End If If Not Application.Intersect(Target, Range("O13,Q13,O14,Q14")) Is Nothing Then If Target.Value <> 0 Then For Each c In Range("O13,Q13,O14,Q14") If c.Address <> Target.Address And c.Row = Target.Row Then c.Value = 0 End If Next c End If End If fin: End Sub
Partager