Excel Vba Named Range Exists

[Solved] Excel Vba Named Range Exists | Vb - Code Explorer | yomemimo.com
Question : excel vba named range exists

Answered by : vastemonde

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

Source : | Last Update : Tue, 26 Jan 21

Answers related to excel vba named range exists

Code Explorer Popular Question For Vb