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 vote316 views1 answer
Programmatically copy data from one workshet to another excel
VBA
1 vote251 views1 answer
Excel vba hide zero values
VBA
0 vote292 views1 answer
Excel vba paste all to each sheet in workbook
VBA
0 vote300 views1 answer
Vba boolean to string
VBA
0 vote269 views1 answer
Remove frist letter from string vbnet
VBA
0 vote257 views1 answer
Vba pass named range to function
VBA
1 vote309 views2 answers
Vba find last row in range for certain criteria
VBA
0 vote282 views1 answer
Excel vba select multiple shapes
VBA
27 votes388 views2 answers
Vba check if file exists
VBA
0 vote285 views1 answer
Loop through lines in text file vb net
VBA