test dbl click 'target' is part of named range
 

Thanks in advance
What is the usual code for testing if an individual cell belongs to a named
range?

test dbl click 'target' is part of named range
 

Use Intersect Method

Set isect = Application.Intersect(Range("rg1"), Range(namedRange))
If isect Is Nothing Then
MsgBox "Ranges do not intersect"
Else
isect.Select
End If


"David" wrote:

Thanks in advance
What is the usual code for testing if an individual cell belongs to a named
range?