Loading one workbooks Names(i) into another

[paipimenta]

Hey Excel people,

I've got a worksheet that end users fill out. Several of these files will be in one folder. I've got a separate report workbook that will select the folder with a dialog and load every file's data (marked with Named cells) into rows on my DataFarm sheet in the report workbook.

I notice a few names that I did not put into the names list that are not visible when I press Ctrl+F3, but are when I MsgBox out the thisName.Name of Names(i)... 'Master-System'!Print_Area and Hawaii!_FilterDatabase. I want to delete these names, but I'm getting a Run Time Error '424': Object required pointing to this code...

            If thisName.Name = "'HI'!_FilterDatabase" Then
                thisName.Delete
            End If

This is preceded by this... and seems to be working fine with the others:

             For Each thisName In Workbooks(Workbooks.Count).Names
                    If thisName.Name = "Extract" Then
                        thisName.Delete
                    End If
 
                    If thisName.Name = "'Master-System'!Print_Area" Then
                        thisName.Delete
                    End If

I viewed this name fine when I did this...

                    'MsgBox ("Names(" & thisName.Index & ") = " & thisName.Name)

so what's up???