Private Sub Worksheet_SelectionChange(ByVal T As Range)
If T.Column = 1 And T.Count = 1 Then
T(1, 2) = "=IFERROR(VLOOKUP(RC[-1],'Affectation Tram'!R1C25:R99999C26,2,FALSE),"""")"
End If
End Sub
Private Sub Worksheet_Change(ByVal T As Range)
If T.Column = 9 Then
T(1, 4) = Environ("username")
T(1, 2) = Date ' dernier ajout
End If
If T.Column = 1 Then
T(1, 3) = Date ' dernier ajout
End If
End Sub
Sub supprimerligne()
Dim l As Long
Application.EnableEvents = False
For l = Cells(Rows.Count, "A").End(xlUp).Row To 2 Step -1
If Cells(l, "k") = "toto" Then Rows(l).ClearContents
Next
Application.EnableEvents = True
End Sub
Sub refresh()
Dim derlig
With Sheets("PCC")
derlig = .Cells(.Rows.Count, "a").End(xlUp).Row
.Range("a2:L" & derlig).Sort Key1:=.Range("a2"), Order1:=xlAscending, Header:=xlYes
End With
' Macro2_Tri_colonne_F Macro
With Worksheets("PCC").[A3:L233]
.Sort Key1:=.Item(6), Order1:=1, Header:=1
End With
End Sub