K
Kerri Grant
I want to create a simple update flag to show when a particular
worksheet has been updated. I only want to identify when particular
cells have been updated, and have tried the following:
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Dim rng As Range
Set rng = Me.Range("J15M24")
If Not Intersect(rng, Target) Is Nothing Then
Range("C2").Value = True
End If
End Sub
The above code almost works, although it changes C2 to TRUE when any
cell in rng is selected, rather than changed. Close, but not quite
there!!
*** Sent via Developersdex http://www.developersdex.com ***
worksheet has been updated. I only want to identify when particular
cells have been updated, and have tried the following:
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Dim rng As Range
Set rng = Me.Range("J15M24")
If Not Intersect(rng, Target) Is Nothing Then
Range("C2").Value = True
End If
End Sub
The above code almost works, although it changes C2 to TRUE when any
cell in rng is selected, rather than changed. Close, but not quite
there!!
*** Sent via Developersdex http://www.developersdex.com ***