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 vote226 views1 answer
Vbs expand env var
VBA
3 votes227 views1 answer
Vba http request json
VBA
0 vote204 views1 answer
Le contrôle SpinButton (Toupie)
VBA
0 vote210 views1 answer
Check range is in another range vba
VBA
0 vote257 views1 answer
VBA Sort RossetaCode
VBA
0 vote227 views1 answer
Vba check if class implements interface
VBA
0 vote221 views1 answer
Vbs
VBA
0 vote210 views1 answer
Get current year vb
VBA
0 vote219 views1 answer
Limit combobox to list vba
VBA
32 votes518 views2 answers
Excel vba column letter
VBA