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 vote138 views1 answer
Vbnet round to nearnest thousand
VBA
0 vote125 views1 answer
Add items to combobox vb.net
VBA
0 vote135 views1 answer
Search in richtextbox vb.net
VBA
3 votes143 views1 answer
Vba double quote
VBA
0 vote133 views1 answer
Vbnet line chart showing extra space
VBA
5 votes153 views1 answer
Excel vba last byte from INTEGER
VBA
0 vote156 views1 answer
Create new worksheet excel visual basic
VBA
0 vote145 views1 answer
Vba count all row
VBA
0 vote136 views1 answer
Worksheet.pastespecial textbox
VBA
5 votes144 views1 answer
Excel vba low word from Long Integer
VBA