title: Double Click Event - Multiple Ranges
body: <p>I'm looking for the best way to code in multiple ranges for my double click event.  </p>
  
  <pre><code>Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
  If Not Intersect(Target, Range("A3:A25")) Is Nothing Then
      'code
  End If
  End Sub
  </code></pre>
  
  <p>As you see above, when A3 to A25 is clicked, the double click event takes place.  But I also have other sections throughout the sheet that I want to include to set off the event.  A29:A40, F3:F37, K3:K40, P3:P40.    </p>
  
  <p>What is the best way to code that without adding new 'If' blocks?<br>
  Or is adding the new 'If' blocks (and calling a subroutine) the best way?</p>