Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean) Dim F As String On Error Resume Next For Each nm In ActiveWorkbook.Names
F = Right(nm.RefersTo, Len(nm.RefersTo) - 1) If Mid(F, 2, 1) = "!" Then F = Left(F, 1) & Me.Name & F F = Replace(F, """", "") End If If TypeName(Range(F)) = "Range" Then If Err = 0 Then If InStr(1, F, Me.Name, vbTextCompare) Then If Not Intersect(Range(nm.Name), Target) Is Nothing Then MsgBox nm.Name End If End If Else Err = 0 End If End If Next End Sub
Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As
Boolean)
Dim F As String
On Error Resume Next
For Each nm In ActiveWorkbook.Names
F = Right(nm.RefersTo, Len(nm.RefersTo) - 1)
If Mid(F, 2, 1) = "!" Then
F = Left(F, 1) & Me.Name & F
F = Replace(F, """", "")
End If
If TypeName(Range(F)) = "Range" Then
If Err = 0 Then
If InStr(1, F, Me.Name, vbTextCompare) Then
If Not Intersect(Range(nm.Name), Target) Is Nothing Then
MsgBox nm.Name
End If
End If
Else
Err = 0
End If
End If
Next
End Sub
Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean) Dim F As String On Error Resume Next For Each nm In ActiveWorkbook.Names
F = Right(nm.RefersTo, Len(nm.RefersTo) - 1) If Mid(F, 2, 1) = "!" Then F = Left(F, 1) & Me.Name & F F = Replace(F, """", "") End If If TypeName(Range(F)) = "Range" Then If Err = 0 Then If InStr(1, F, Me.Name, vbTextCompare) Then If Not Intersect(Range(nm.Name), Target) Is Nothing Then MsgBox nm.Name End If End If Else Err = 0 End If End If Next End Sub