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

0 vote307 views1 answer
Vba code to select image in sheet
VBA
0 vote311 views1 answer
Excel vba show developer tab
VBA
0 vote309 views1 answer
Excel vba copy entire sheet paste values
VBA
1 vote343 views1 answer
Excel how to format bytes as KB, MB, GB
VBA
0 vote324 views1 answer
Excel VBA web scraping
VBA
0 vote312 views1 answer
Reset border color textbox vba
VBA
0 vote329 views1 answer
Vba cell all borders
VBA
0 vote307 views1 answer
Vba text to general
VBA
0 vote343 views1 answer
Create links in msgbox in vb
VBA
0 vote364 views1 answer
Vba userform textbox wrap text
VBA