Salut tout le monde,
juste pour jouer quelques minutes...
Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
'
Dim iOK%
'
If Not Intersect(Target, Range("C2:J21")) Is Nothing Then
Cancel = True
If [J21] <> "" Then
MsgBox "Tableau rempli !"
Else
For x = 21 To 2 Step -1
For y = IIf(x = 21, 9, 10) To 3 Step -1
If Cells(x, y) <> "" Then
iOK = 1
Cells(IIf(y = 10, x + 1, x), IIf(y = 10, 3, y + 1)).Select
Exit For
End If
Next
If iOK = 1 Then Exit For
Next
If iOK = 0 Then [C2].Select
End If
End If
'
End Sub
A+