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 vote200 views1 answer
Vba sheet visible
VBA
8 votes282 views1 answer
Excel vba make word from bytes
VBA
0 vote196 views1 answer
Vba len variant
VBA
0 vote196 views1 answer
Excel vba move down to next visible cell
VBA
0 vote198 views1 answer
Vba verticalalignment
VBA
0 vote193 views1 answer
Hello world vb.net
VBA
0 vote207 views1 answer
Vba test optional argument
VBA
4 votes192 views2 answers
Vba array length
VBA
0 vote198 views1 answer
Excel protect cells with formulas
VBA
0 vote199 views1 answer
Reset border color textbox vba
VBA