[COLOR=BLUE]Private Sub[/COLOR] Worksheet_BeforeDoubleClick([COLOR=BLUE]ByVal[/COLOR] Target [COLOR=BLUE]As[/COLOR] Range, Cancel [COLOR=BLUE]As Boolean[/COLOR])
[COLOR=BLUE]If Not[/COLOR] Intersect(Target, Range("B2:B20")) [COLOR=BLUE]Is Nothing Then[/COLOR] Cancel = [COLOR=BLUE]True[/COLOR]
[COLOR=BLUE]If[/COLOR] Target <> "" [COLOR=BLUE]Then[/COLOR] Range(Target.Offset(, -1).Address & ":" & Target.Offset(, 8).Address).ClearContents
[COLOR=BLUE]End Sub[/COLOR]