So I am iterating through all the ranges in a worksheet. However, if a range is a part of a workbook then it is not showing up. When I initially add a range to a sheet it does not assign it to the worksheet.
Example: If I copy a worksheet over I get
RangeName 'SheetName' in the range Define section of Excel
if I create the range on that sheet I get
Then when I iterate through it only picks up the Ranges on the worksheet with RangeName 'SheetName'
How can I either add a range to get that RangeName 'SheetName' format in the Name->Define section or how can I check for ranges without the 'SheetName' element.
For Each nm In wks.Names
'delim = GetPathSection(nm.Name, 2, "!")
If delim <> "" Then
missing = missing & delim & "; "