test dbl click 'target' is part of named range

  • Thread starter Thread starter David
  • Start date Start date
D

David

Thanks in advance
What is the usual code for testing if an individual cell belongs to a 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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Doube click cell to run macro 1
Cell values to an array, then array transpose to another workbook 8
VBA set thick borders around non empty cells in range 0
Clear a "moving" range offset from Target 31
Trying to run excel vba code when cell value changes from empty to entered value. 1
Loop is slow trying array code 17
Junp start my Select Case Macro 12
Named Range maker code 9

Back
Top