Thanks in advance What is the usual code for testing if an individual cell belongs to a named range?
D David Sep 18, 2008 #1 Thanks in advance What is the usual code for testing if an individual cell belongs to a named range?
J Joel Sep 18, 2008 #2 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
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
