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

-1 vote299 views1 answer
How save excel through visual basic
VBA
0 vote306 views1 answer
Vbnet convert charatcer to binary
VBA
0 vote278 views1 answer
.net dark title bar
VBA
0 vote266 views1 answer
Excel vba disable mouse click
VBA
1 vote272 views1 answer
Vba compile error object required
VBA
0 vote293 views1 answer
Vba range clear formatting
VBA
0 vote268 views1 answer
Excel vba extract year
VBA
0 vote267 views1 answer
Vba file size
VBA
2 votes273 views2 answers
Excel vba copy values range to another range
VBA
0 vote274 views1 answer
Vba option button selected
VBA