If Err = 424 Then Set wbCall = ActiveWorkbookĮlseIf Not Intersect(Range(celRef), Range(iName.RefersTo)) Is Nothing Then If Err = 424 Then celRef = Range(celRef).Parent.Name & '!' & celRef Public Function NAMEDRANGE(celRef As Variant) As Stringĭim iName As Name, wbCall As Workbook, blnApprox As BooleanĬelRef = & '!' & celRef Will return approximate results if range intersects a Named Range. Value can be passed as a String or Range. This can also be used for Named Ranges that do not refer to locations, but rather values. This can be used as a worksheet function or via VBA code. One may have a need to look at the name of a cell (Named Range) or to check if a name occupies a specific location in a workbook. If you would like to check if a named range is occupying a specific range in Excel, this UDF can return the name the string is referring to or 'Not Found' if no matching is found. Return Named Range Name from Refers To Value