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 vote230 views1 answer
Vba apostrophe chr
VBA
0 vote270 views1 answer
How to enter Vbox manage commands
VBA
0 vote228 views1 answer
Vba type variable
VBA
1 vote239 views1 answer
Excel vba array remove first
VBA
0 vote233 views1 answer
Excel vba delete folder
VBA
5 votes257 views1 answer
Excel vba last byte from INTEGER
VBA
0 vote270 views1 answer
Vbnet add axis labels to chart
VBA
1 vote222 views1 answer
Vba declare api 64 bit 32 bit
VBA
0 vote223 views1 answer
Excel vba calculate
VBA
0 vote231 views1 answer
Move bindingnavigator vb
VBA