Excel vba named range exists

Function NamedRangeExist(ByRef pWorkBook As Workbook, pName As String) As Boolean
    Dim nName As Name
    For Each nName In pWorkBook.Names
        If nName.Name = pName Then
            NamedRangeExist = True
            Exit Function
        End If
    Next nName
End Function

Similar codes

22 votes248 views1 answer
Excelvba check for directory
VBA
6 votes183 views1 answer
Excel vba get the path of current workbook
VBA
0 vote192 views1 answer
Send webhook vbscript
VBA
8 votes210 views1 answer
Excel vba determine number of elements in a 2D array
VBA
0 vote196 views1 answer
Vbnet convert charatcer to binary
VBA
1 vote136 views1 answer
Vba exit do while
VBA
0 vote193 views1 answer
Excel vba combine ranges
VBA
0 vote187 views1 answer
Search combobox items vb.net
VBA
0 vote176 views1 answer
Change form background image vb
VBA
0 vote180 views1 answer
Switch pictures with buttons vb.net
VBA