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 vote300 views1 answer
Vba clear collection
VBA
0 vote287 views1 answer
Excel vba Column Name to Column Number
VBA
1 vote297 views2 answers
Vba string length
VBA
0 vote312 views1 answer
Excel delete ever other vba
VBA
0 vote306 views2 answers
Checking and changing system volume vb.net
VBA
0 vote304 views1 answer
Excel vba protect sheet
VBA
8 votes332 views1 answer
Excel vba make integer
VBA
0 vote297 views1 answer
Vba remove last vbcrlf
VBA
0 vote305 views1 answer
Regex numeric digits
VBA
0 vote289 views1 answer
Power query M substract minimum value of column -dax
VBA