Re,
Merci pour ton retour,
A tester....
Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
Dim plage As Range
Dim dl As Long, dc As Long
dc = Sheets("Feuil1").Cells(1, Cells.Columns.Count).End(xlToLeft).Column
dl = Sheets("Feuil1").Range("A" & Rows.Count).End(xlUp).Row
Set plage = Sheets("Feuil1").Range(Cells(2, 1), Cells(dl, dc))
If Not Application.Intersect(Target, plage) Is Nothing Then
If Target.Value = "" Then Exit Sub
Sheets("Feuil2").Activate
Sheets("Feuil2").Rows(Target).Select
End If
Cancel = True
End Sub
L'ajout de ligne où de colonne est pris en compte (à condition que la colonne A et la ligne 1 soient remplies).
Cordialement,