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 vote348 views1 answer
Prive sub enter clicked vb
VBA
1 vote375 views1 answer
Vba login website
VBA
0 vote340 views1 answer
How to get the value of optionbutton in vba
VBA
0 vote309 views1 answer
Excel vba assign shortcut key to button
VBA
0 vote359 views1 answer
Excel delete ever other vba
VBA
0 vote333 views1 answer
Vba leading zeros in string
VBA
0 vote349 views1 answer
Vbnet access System.InvalidOperationException: 'Update requires a valid UpdateCommand when passed DataRow collection with modified rows.'
VBA
1 vote321 views1 answer
Excel vba first and last row and column in range
VBA
1 vote292 views1 answer
Ms access open form to new record
VBA
8 votes377 views1 answer
Run command pormpt in background windows
VBA