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 vote223 views1 answer
Default host vbox address
VBA
1 vote222 views1 answer
Excel vba Run a Macro every time sheet is changed
VBA
0 vote214 views1 answer
Vbnet get file name from path
VBA
0 vote226 views1 answer
Write listbox to text file vb.net
VBA
1 vote223 views1 answer
Random number generator vb.net
VBA
1 vote210 views1 answer
Excel vba convert cells(1,1) into A1 and vice versa
VBA
0 vote217 views1 answer
Vbnet make a string to unicode converter
VBA
0 vote228 views1 answer
Vba code for cutoff time
VBA
4 votes230 views1 answer
Excel vba how to programmatically remove the marching ants after range copy
VBA
0 vote210 views1 answer
Dynamically change drop down list visual basic
VBA