Re: List of all names in EXCEL workbook

From: Dariotto (Dariotto_at_discussions.microsoft.com)
Date: 03/07/05 

Date: Mon, 7 Mar 2005 08:45:06 -0800

Hi,
I had the same problem to manage a huge list of names.
I have found 2 solutions:
1) I made a macro that add a new work*** and then recurse all the names
writing the info of each name on a single row of the new wks:
Set oWksSource = Application.ActiveWorkbook
Set oWksOutput = Application.Workbooks.Add(xlWorksheet).Worksheets(1)
For Each oName In oWksSource.Names
        sName = oName.Name
        sRif = oName.RefersTo
        bVisibile = oName.visible
        oWksOutput.Cells(lRow, 1).Value = sName
        oWksOutput.Cells(lRow, 2).Value = "'" & sRif
        oWksOutput.Cells(lRow, 3).Value = bVisibile
        lRow = lRow + 1
Next oName

2) a freeware utility: NameManager (www.jkp-ads.com)
  

"NameSearcher" wrote:

> Suggestion is on point but I can't seem to bring up the sequence. I have
> EXCEL 2000. I have tried the Tools\Customize\ command and tried to set up a
> custom menu bar with the Insert List but I haven't been able to get it to
> work. Maybe walk me through it slower. Thanks.
>
>
> "arno" wrote:
>
> > Menu Insert/Names/Insert/Insert List
> >
> > arno
> >
> > "NameSearcher" <NameSearcher@discussions.microsoft.com> schrieb im
> > Newsbeitrag news:6A01CCCC-5484-4684-8316-FF376F5B7B20@microsoft.com...
> > > How do I get a list of all the names being used in an EXCEL workbook?
> > The
> > > "Insert\Names... " sequence of commands gets a list you can view on
> > the
> > > screen, about 10 at a time. I would like to copy/paste the whole
> > list. I
> > > would also like the list to include (as a separate column) associated
> > text
> > > showing the references for each name.
> >
> >

Loading