Option Explicit
Sub SupprOp()
Dim col%, lg1&, lg2&
With ActiveCell
col = .Column: If col > 1 Then Exit Sub
lg1 = .Row: If lg1 < 9 Then Exit Sub
If .Offset(, 1) = "" Then Exit Sub
End With
lg2 = lg1 + 1
Do While Cells(lg2, 2) = "" And Cells(lg2, 3) <> ""
lg2 = lg2 + 1
Loop
lg2 = lg2 - 1
If MsgBox("Voulez-vous supprimer l'opération n° " & Cells(lg1, 2) _
& " ?", 36) = 6 Then Rows(lg1 & ":" & lg2).Delete
End Sub