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

5 votes166 views1 answer
Xl vba double quotes in string literal
VBA
0 vote158 views1 answer
Vba string
VBA
0 vote166 views1 answer
Rotate image by any angle vb.net
VBA
0 vote150 views1 answer
Remove frist letter from string vbnet
VBA
6 votes163 views1 answer
Excel vba check if a string only contains alpha characters
VBA
5 votes197 views1 answer
Vba low word from Long Integer
VBA
0 vote172 views2 answers
Vba remove line breaks
VBA
0 vote169 views4 answers
How to continue formula in below line in vba code
VBA
0 vote169 views1 answer
Sort dictionary by key vba
VBA
9 votes302 views2 answers
Excel vba convert 2 Short integers to a Long integer
VBA