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 vote206 views1 answer
Vb ternary
VBA
0 vote190 views1 answer
VBA
VBA
0 vote181 views1 answer
Weekday vba
VBA
31 votes319 views1 answer
Excel-vba how to convert a column number into an excel column
VBA
0 vote164 views1 answer
Faire appel à la mise en forme conditionnelle vba excel
VBA
1 vote186 views1 answer
How to remove zeros in excel
VBA
1 vote184 views1 answer
Add rows to datagridview vb.net
VBA
0 vote166 views1 answer
Excel vba show developer tab
VBA
0 vote190 views1 answer
Vba clear collection
VBA
0 vote165 views1 answer
Get current year vb
VBA