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 vote309 views1 answer
Excel last used row
VBA
1 vote280 views1 answer
Excel vba first and last row and column in range
VBA
0 vote285 views1 answer
Vba sort multiple columns
VBA
0 vote293 views1 answer
Vb get ip address
VBA
3 votes314 views1 answer
Excel vba make long from two shorts
VBA
3 votes326 views1 answer
Vba post request json
VBA
0 vote293 views1 answer
Excel vba disable keyboard input
VBA
1 vote288 views1 answer
Excel format cell as kilowatts
VBA
0 vote290 views1 answer
Excel protect cells with formulas
VBA
0 vote293 views1 answer
Vba leading zeros in string
VBA