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

-1 vote308 views1 answer
How to correct a number to 2 decimal places in vba
VBA
13 votes441 views2 answers
Vba write text file
VBA
0 vote297 views1 answer
Le contrôle SpinButton (Toupie)
VBA
0 vote310 views1 answer
Vba find sub dictionary
VBA
0 vote349 views1 answer
Excel vba protect scenarios
VBA
5 votes350 views1 answer
Excel vba get user selected range
VBA
0 vote307 views1 answer
Default host vbox address
VBA
0 vote318 views1 answer
Excel vba StartUpPosition
VBA
0 vote327 views1 answer
How to enter Vbox manage commands
VBA
0 vote322 views1 answer
Priavte sub with multiple handels find sneder
VBA