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 vote154 views1 answer
Excel vba Refreshing all pivot tables in workbook
VBA
0 vote147 views1 answer
Vbnet chart make 0 gridline line different color
VBA
1 vote147 views2 answers
Get all column names from excel vba
VBA
0 vote148 views1 answer
Vba code for cutoff time
VBA
0 vote158 views4 answers
How to continue formula in below line in vba code
VBA
1 vote147 views1 answer
Vba delete file
VBA
0 vote160 views1 answer
Convert number to minutes in vba
VBA
1 vote155 views1 answer
Set font for ms chart vb.net
VBA
2 votes143 views1 answer
Vba uppercase first letter of each word
VBA
1 vote152 views1 answer
Highlight selected cell in excel vba
VBA