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

1 vote355 views1 answer
Vba compile error object required
VBA
0 vote395 views1 answer
Sort dictionary by key vba
VBA
0 vote348 views1 answer
Convert Seconds to HH:MM:SS in VB.Net
VBA
1 vote362 views1 answer
Vba reverse string
VBA
0 vote345 views1 answer
Excel vba populate array with cell values
VBA
0 vote384 views1 answer
Vba sort the data Z to A
VBA
6 votes402 views1 answer
Excel vba check if a string only contains letters
VBA
8 votes469 views1 answer
Excel vba make a short integer from two bytes
VBA
0 vote363 views1 answer
Vbscript check if string is empty
VBA
0 vote362 views1 answer
Vbnet line graph smooth lines
VBA