Private Sub Woorksheet_SelectionChange(ByVal Target As Range)
End Sub
Dim fin As Integer, plage As Range, cellule As Range
.Range("B29") = Range("F" & Target.Row)
Set plage = Range("A2:Q" & fin)
.Range("B29") = Range("F" & Target.Row)
.Range("B29") = Cells(5, Target.Column)
Dim fin As Integer, plage As Range, cellule As Range, li As Byte
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
fin = Range("F65536").End(xlUp).Row
Set plage = Range("A2:Q" & fin)
If Target.Count > 1 Then Exit Sub
If Not Application.Intersect(Target, plage) Is Nothing Then
li = 29
For Each cellule In plage
If Target = cellule Then
With Sheets("Soumission")
li = IIf(.Range("A29") = "PRÉ VERNIS", 30, 29)
.Range("A" & li) = "PRÉ VERNIS"
.Range("B" & li) = Cells(5, Target.Column)
.Range("J" & li) = Target.Value
Exit Sub
End With
End If
Next
End If
End Sub
Dim fin As Integer, plage As Range, cellule As Range, i As Integer
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
fin = Range("F65536").End(xlUp).Row
Set plage = Range("A2:Q" & fin)
If Target.Count > 1 Then Exit Sub
If Not Application.Intersect(Target, plage) Is Nothing Then
For Each cellule In plage
If Target = cellule Then
With Sheets("Soumission")
If .Range("A29") = "" Then i = 0 Else i = i + 1
.Range("A29").Offset(i, 0) = "PRÉ VERNIS"
.Range("B29").Offset(i, 0) = Cells(5, Target.Column)
.Range("J29").Offset(i, 0) = Target.Value
Exit Sub
End With
End If
Next
End If
End Sub