Re: $$Excel-Macros$$ Time Stamp Limited to Target Cells Within a Specic Range

2014-04-25 Thread Paul Schreiner
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

Re: $$Excel-Macros$$ Time Stamp Limited to Target Cells Within a Specic Range

2014-04-25 Thread Vabs
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.