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 vote301 views1 answer
Vba count all row
VBA
1 vote283 views2 answers
Get all column names from excel vba
VBA
0 vote281 views1 answer
Search for text in every worksheet excel visual basic
VBA
0 vote230 views1 answer
How to self delete a vbscript file
VBA
0 vote271 views1 answer
Vba shape transparent
VBA
0 vote254 views1 answer
Quit excel with save changes dialog vb.net
VBA
0 vote283 views1 answer
Vba check if class implements interface
VBA
-1 vote280 views1 answer
Vba code to add new column in table
VBA
0 vote276 views1 answer
Vbnet check if string is only numbers
VBA
0 vote291 views1 answer
Excel vba copy range with filter
VBA