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

1 vote253 views1 answer
Vba loop through files in folder
VBA
15 votes295 views2 answers
Xl vba dynamic string array
VBA
0 vote238 views1 answer
Excel vba saveas no prompt for overwrite
VBA
0 vote237 views1 answer
Excel vba remove formatting from cell
VBA
1 vote237 views1 answer
How to check is the value enterd is a number or text in vba
VBA
0 vote242 views1 answer
Date as number vb
VBA
0 vote247 views1 answer
Vba range clear formatting
VBA
0 vote240 views1 answer
Excel vba unlock sheet without password
VBA
-1 vote240 views1 answer
VBA check if a cell contains a letter or string
VBA
0 vote245 views1 answer
Vba find last column in a row with data
VBA