VBA Mouse Click Event I need contained to specific area

[steves424]

I have a Macro for putting an X in a sheet that I need contained to cells B14 - R21. The double click Macro works perfect, I just want it contained to the specific range:

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
Target = "X"
End Sub

If someone could help it would be much appreciated.

[HaHoBe]

Hi, steves424,

maybe

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
If Not Intersect(Target, Range("B14:R21")) Is Nothing Then
  Target = "X"
  Cancel = True
End If
End Sub

Ciao,
Holger

[steves424]

Worked, awesome