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 vote150 views1 answer
Dynamic array vba
VBA
0 vote144 views1 answer
Vba code to select image in sheet
VBA
0 vote158 views1 answer
Excel last used row
VBA
1 vote148 views1 answer
Highlight selected cell in excel vba
VBA
0 vote154 views1 answer
Vbs expand env var
VBA
0 vote197 views2 answers
VB
VBA
0 vote137 views1 answer
Vba text to general
VBA
0 vote138 views1 answer
Vba add shape oval
VBA
1 vote139 views1 answer
Excel vba saveas force overwrite
VBA
0 vote147 views1 answer
Vba extract filename from path
VBA