xl vba test if target is named range code example
Example: excel vba test if target is a named range
If Not Intersect(Target, [NamedRangeName]) Is Nothing Then
If Target.Cells.Count = [NamedRangeName].Cells.Count Then
If Target.row = NamedRange.row Then
If Target.Column = NamedRange.Column Then
End If
End If
End If
End If
Function TargetIsNamedRange(Target As Range, NamedRange As Range) As Boolean
If Not Intersect(Target, NamedRange) Is Nothing Then
If Target.Cells.Count = NamedRange.Cells.Count Then
If Target.Row = NamedRange.Row Then
If Target.Column = NamedRange.Column Then
TargetIsNamedRange = True
Exit Function
End If
End If
End If
End If
End Function