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 vote157 views1 answer
VB Error Code BC30201
VBA
1 vote160 views1 answer
Random number generator vb.net
VBA
0 vote163 views1 answer
Excel PasteSpecial Format:= can't find the argument
VBA
0 vote154 views1 answer
Vbs exec hidden
VBA
0 vote154 views1 answer
Vbnet dynamically change excel sheet name
VBA
0 vote155 views1 answer
Excel vba join variant array
VBA
0 vote173 views1 answer
How to add line graph vb net
VBA
5 votes179 views1 answer
Vba low byte from INTEGER
VBA
1 vote148 views1 answer
How to do error handling in access vba
VBA
0 vote164 views1 answer
Vbnet check if sting contians symbols
VBA