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 vote298 views1 answer
How to make a a msgbpx in vbs
VBA
1 vote330 views1 answer
Excel vba Populating a combobox on a userform from a range of cells
VBA
5 votes370 views1 answer
Excel vba last byte from INTEGER
VBA
0 vote297 views1 answer
Find days in month vba
VBA
0 vote313 views1 answer
Excel vba protect content
VBA
1 vote307 views2 answers
Vba string to date
VBA
-1 vote297 views1 answer
For i in range vba
VBA
0 vote306 views1 answer
Excel vba delete folder
VBA
31 votes439 views1 answer
Excel-vba how to convert a column number into an excel column
VBA
2 votes327 views1 answer
Excel vba check if string entirely alpha
VBA