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 vote238 views1 answer
How save excel through visual basic
VBA
0 vote196 views1 answer
Vba leading zeros in string
VBA
0 vote229 views1 answer
Excel vba move down to next visible cell
VBA
0 vote191 views1 answer
Excel vba concatenate range
VBA
0 vote214 views1 answer
VBA Loop to range
VBA
0 vote207 views1 answer
Telephon call in vba
VBA
0 vote211 views1 answer
Discern between file and folder given path vb.net
VBA
0 vote219 views1 answer
Vba keep command window open
VBA
5 votes228 views1 answer
Excel vba tool to help with refactoring code
VBA
1 vote198 views1 answer
Excel vba last column in range
VBA