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

5 votes420 views1 answer
Excel vba get low byte from INTEGER
VBA
9 votes489 views2 answers
Excel vba convert 2 Short integers to a Long integer
VBA
2 votes328 views1 answer
Excel vba extract file name
VBA
0 vote352 views1 answer
Vba test optional argument
VBA
0 vote329 views1 answer
Vba add month to date
VBA
1 vote345 views1 answer
Vba date to unix timestamp
VBA
1 vote334 views1 answer
Vba compile error object required
VBA
0 vote358 views1 answer
How to format a textbox as date vb net
VBA
0 vote342 views1 answer
Vbnet get file name from path
VBA
8 votes466 views1 answer
Vba make a short integer from two bytes
VBA