I am trying to set up some code that loops through the named ranges in a workbook and am encountering some errors. Some digging led me to discover that the the first named range the code finds is "=#NAME?"
Sub test() Dim nameDrawing As Name For Each nameDrawing In ActiveWorkbook.Names Debug.Print nameDrawing.Value Next nameDrawing End Sub
in the immediate window.
The name manager window does not show any named ranges with any errors that I can see.
If anyone has any ideas on what could be causing the errant named range, I would appreciate the help.