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

25 votes488 views2 answers
Excel vba folder exist
VBA
0 vote353 views1 answer
Not allow form to be resized
VBA
0 vote367 views1 answer
Check if cell is dbnullvb.net
VBA
27 votes498 views2 answers
Vba check if file exists
VBA
0 vote369 views1 answer
Vba run command
VBA
2 votes356 views1 answer
Vba ado ace sql alias ignored for calculated column
VBA
0 vote332 views1 answer
Docker vboxmanage not found
VBA
1 vote337 views1 answer
Vbscript convert ascii code to character
VBA
5 votes398 views1 answer
Excel-vba get integer high byte
VBA
0 vote356 views1 answer
Excel vba textbox forecolor disabled
VBA