Thread: test dbl click 'target' is part of named range
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
joel joel is offline
external usenet poster
  
Posts: 9,101
Default 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?
Reply With QuoteReply With Quote