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 vote121 views1 answer
Excel vba range contains
VBA
0 vote118 views1 answer
Excel vba copy range with filter
VBA
1 vote75 views1 answer
Vba Remove Case Sensitivity
VBA
0 vote128 views1 answer
Vba variable number of arguments
VBA
0 vote111 views1 answer
Excel vba populate array with cell values
VBA
1 vote133 views1 answer
Change the first item in a queue vb.net
VBA
1 vote116 views1 answer
Excel vba compare 2 rows
VBA
0 vote113 views1 answer
Vb net check if file exists
VBA
0 vote133 views1 answer
Vba is integer
VBA
0 vote138 views1 answer
Vba range clear formatting
VBA