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

15 votes238 views1 answer
Excel vba wait
VBA
22 votes266 views1 answer
Excelvba check for directory
VBA
0 vote199 views1 answer
Excel vba automatic calculation
VBA
8 votes210 views1 answer
Run command pormpt in background windows
VBA
3 votes205 views1 answer
Vba double quote
VBA
1 vote185 views1 answer
Excel vba hide zero values
VBA
-1 vote182 views2 answers
How close excel through visual basic
VBA
3 votes241 views1 answer
Vba continue for each loop
VBA
5 votes215 views1 answer
Excel vba low word from Long Integer
VBA
0 vote191 views1 answer
Vba pass named range to function
VBA