FindName

Finds if a name (Range name) is found in a certain workbook or not
Workbook is expected to be open in same Excel session

Function FindName(Name, Optional WB= "This") As Boolean
 FindName = False
 If WB = "This" Then WB = ThisWorkbook.Name
 If FindFile(WB) Then
  For i = 1 To Workbooks(WB).Names.Count
   If Workbooks(WB).Names(i).Name = Name Then FindName = True: Exit For
  Next i
 End If
End Function

Name, Optional WB

Views 406 Downloads 145

'Name', 'range', 'range name', 'Excel', 'workbook', 'formula'

ANmarAmdeen
323
Attachments
Sessions VBA-Excel
Revisions

v2.0