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 vote198 views1 answer
Vbs run with cscript
VBA
1 vote179 views1 answer
VBA Loop through recordset
VBA
0 vote196 views1 answer
Vbs expand env var
VBA
0 vote198 views1 answer
Tester si une case est vide vba
VBA
25 votes434 views3 answers
String to date vb
VBA
2 votes181 views2 answers
Excel vba copy values range to another range
VBA
0 vote195 views1 answer
Excel vba textbox forecolor disabled
VBA
0 vote173 views1 answer
Change "location" of binding navigator vb
VBA
1 vote179 views1 answer
Vba delete array element
VBA
1 vote180 views1 answer
Excel vba get ordinal number from cardinal number
VBA