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 vote226 views1 answer
Vbs
VBA
0 vote224 views1 answer
Vbscript remove spaces from string
VBA
0 vote216 views1 answer
Type excel.application is not defined vb
VBA
0 vote238 views1 answer
Prive sub enter clicked vb
VBA
0 vote234 views1 answer
Vba check if class implements interface
VBA
6 votes237 views1 answer
Excel vba check if a string only contains alpha characters
VBA
0 vote232 views1 answer
Ribbon show/hide
VBA
0 vote245 views1 answer
How to make a a msgbpx in vbs
VBA
0 vote213 views1 answer
How to set location and size of new from vb
VBA
1 vote227 views1 answer
How to check is the value enterd is a number or text in vba
VBA