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 vote128 views1 answer
Refer to resource using string variable vb.net
VBA
0 vote129 views1 answer
Check if program is running vbnet
VBA
0 vote117 views1 answer
Get current year vb
VBA
0 vote121 views1 answer
Openfiledialog specific folder
VBA
0 vote129 views1 answer
Vba get application version
VBA
0 vote116 views1 answer
Excel vba ternary
VBA
3 votes137 views1 answer
Vba double quote
VBA
0 vote133 views1 answer
Windows Presentation Foundation dark title bar
VBA
0 vote131 views1 answer
String contins in vba
VBA
1 vote147 views1 answer
S yyyy-MM-dd HH:mm:ss Short Date Local
VBA