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

3 votes152 views1 answer
Excel vba read registry key value
VBA
1 vote150 views1 answer
Vba reverse string
VBA
0 vote146 views1 answer
Excel vba concatenate range
VBA
0 vote234 views1 answer
Application.ExecutablePath VB.NET
VBA
0 vote168 views1 answer
How to get value from clipboard in vbnet
VBA
0 vote161 views1 answer
Discern between file and folder given path vb.net
VBA
0 vote146 views1 answer
Excel text to columns line break
VBA
0 vote167 views1 answer
VBA is form loaded
VBA
3 votes157 views1 answer
Vba request json
VBA
0 vote154 views1 answer
Vbnet check if number is even or odd
VBA