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 vote151 views1 answer
How to remove zeros in excel
VBA
0 vote162 views1 answer
Search for text in every worksheet excel visual basic
VBA
0 vote145 views1 answer
Refresh token em vb net
VBA
8 votes257 views1 answer
Vba make a short integer from two bytes
VBA
0 vote136 views1 answer
Returns an array from function vba
VBA
1 vote142 views1 answer
Shortcut to apply a formula to an entire column in excel
VBA
8 votes219 views1 answer
Excel vba determine number of elements in a 1D array
VBA
0 vote137 views1 answer
Select case vba
VBA
22 votes261 views1 answer
Excel vba check if directory exists
VBA
0 vote132 views1 answer
Vba createparameter null
VBA