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 vote255 views1 answer
Weekday vba
VBA
0 vote264 views1 answer
Pivot data source not accepting table named range vba
VBA
0 vote229 views1 answer
Excel vba disable copy paste
VBA
0 vote256 views1 answer
Vba sort the data Z to A
VBA
1 vote248 views1 answer
Excel vba array remove first
VBA
0 vote237 views1 answer
Change "location" of binding navigator vb
VBA
1 vote250 views2 answers
Vba function return array
VBA
1 vote250 views1 answer
Vb.net get name by Cell Click
VBA
0 vote250 views1 answer
Vba remove numbers from string
VBA
0 vote229 views1 answer
Excel vba assign shortcut key to button
VBA