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 votes356 views1 answer
Excel vba high word from Long Integer
VBA
1 vote378 views1 answer
How to INPUT text in shape with enter and spacein vba
VBA
1 vote354 views1 answer
How to open cmd with vbd
VBA
0 vote358 views1 answer
Excel vba join variant array
VBA
0 vote406 views1 answer
Application.ExecutablePath VB.NET
VBA
0 vote357 views1 answer
Remove frist letter from string vbnet
VBA
0 vote413 views1 answer
Supprimer la valeur de celule vba
VBA
0 vote385 views1 answer
Make your computer talk vbscript
VBA
0 vote368 views1 answer
WGET FTP
VBA
0 vote385 views1 answer
Vba add shape oval
VBA