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 vote168 views1 answer
Vba first cell in range
VBA
4 votes184 views2 answers
Excel vba last column with data
VBA
0 vote195 views1 answer
VBA
VBA
0 vote169 views1 answer
Vba len variant
VBA
1 vote176 views1 answer
Vba refresh pivot table
VBA
0 vote178 views1 answer
Openfiledialog specific folder
VBA
0 vote175 views1 answer
System.Runtime.InteropServices.COMException: 'Call was rejected by callee. (Exception from HRESULT: 0x80010001
VBA
0 vote179 views4 answers
How to continue formula in below line in vba code
VBA
0 vote182 views1 answer
Refresh token em vb net
VBA
0 vote180 views1 answer
Vba add spaces
VBA