Try testing to see if the selected target "intersects" the specified range:
If (Not Intersect(Range(Target.Address), Range("D5:G10")) Is Nothing) Then
Paul
-
“Do all the good you can,
By all the means you can,
In all the ways you can,
In all the places y
Hi
PFA
Cheers!
On Fri, Apr 25, 2014 at 4:47 PM, Mark Lefcowitz wrote:
> I want to be able to point-and-click to individual cells within a
> specified worksheet range and inset a now() timestamp:
>
> Option Explicit
> Private Sub Worksheet_SelectionChange(ByVal Target As Range)
> If Target.