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 vote236 views1 answer
Vbnet find highest value in chart
VBA
0 vote235 views1 answer
Vbnet check if string is only symbols
VBA
8 votes552 views1 answer
Excel vba make word from bytes
VBA
0 vote249 views1 answer
Filesystemobject vba reference
VBA
0 vote250 views1 answer
Putting marquee in vb.net
VBA
0 vote232 views1 answer
Vba run command
VBA
-1 vote233 views1 answer
VBA check if a cell contains a letter or string
VBA
22 votes531 views1 answer
Excelvba check for directory
VBA
0 vote242 views1 answer
Excel delete ever other vba
VBA
0 vote227 views1 answer
Vba find last column in a row with data
VBA