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 vote198 views1 answer
Vbnet check if string is only symbols
VBA
0 vote214 views1 answer
Vba check 32 or 64 bit
VBA
1 vote212 views1 answer
Add a index column power bi
VBA
0 vote222 views1 answer
Vba add spaces
VBA
0 vote242 views1 answer
COMO GRAVAR U VALOR NO ARQUIVO APPSETINGS EM VB NET
VBA
0 vote216 views1 answer
Get month number from month name vbnet
VBA
0 vote221 views1 answer
Vba static variable
VBA
0 vote212 views1 answer
Excel vba clear filter
VBA
0 vote213 views1 answer
Excel vba show developer tab
VBA
0 vote207 views1 answer
VBA Loop to range
VBA