I need to know if a name is already in use in Excel (for example as a named range) so that I do not allow the attempted creation of duplicate names. I tried the following but the loop body never executes (there are no exceptions thrown, it just looks like the collection is empty).
Can anyone suggest and alternative?
        foreach (Excel.Name n in _workbook.Names)
        {
            if (n.Name == name) return true;
        }
        return false;