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 vote163 views1 answer
Vbnet check if string is only symbols
VBA
0 vote211 views1 answer
Vba ternary
VBA
0 vote184 views1 answer
Excel vba DisplayAlerts
VBA
12 votes298 views1 answer
Excel vba write string to text file
VBA
2 votes163 views1 answer
Excel vba extract file name
VBA
0 vote168 views1 answer
Loop through lines in text file vb net
VBA
0 vote168 views1 answer
Nested if else in vb.net
VBA
0 vote166 views1 answer
Excel vba saveas no prompt for overwrite
VBA
0 vote174 views1 answer
Vba sort multiple columns
VBA
0 vote186 views2 answers
Checking and changing system volume vb.net
VBA