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

-1 vote119 views1 answer
VBA check if a cell contains a letter or string
VBA
0 vote160 views1 answer
How to call gcd in vba
VBA
3 votes140 views1 answer
Extract word in a text in excel
VBA
0 vote122 views1 answer
Vbnet check if string is only symbols
VBA
0 vote129 views1 answer
Dynamically change drop down list visual basic
VBA
0 vote127 views1 answer
Vba variable number of arguments
VBA
0 vote110 views1 answer
Excel vba milliseconds
VBA
0 vote120 views1 answer
Vb net show lines for all axis labels in chart
VBA
0 vote132 views1 answer
Vba exit while
VBA
2 votes110 views2 answers
Constructor vb.net
VBA