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 vote279 views1 answer
Excel vba ternary
VBA
0 vote279 views1 answer
Vba table header name
VBA
1 vote305 views2 answers
Vba find last row in range for certain criteria
VBA
0 vote251 views1 answer
Vb.net round to 2 decimal places
VBA
0 vote264 views1 answer
Vba DisplayGridlines
VBA
0 vote276 views1 answer
Limit combobox to list vba
VBA
0 vote256 views1 answer
Vbnet add new ecel sheet
VBA
0 vote283 views1 answer
Vbnet cycle through charaters in string
VBA
1 vote290 views1 answer
Excel vba Populating a combobox on a userform from a range of cells
VBA
0 vote286 views1 answer
Vba is integer
VBA