Re: List of all names in EXCEL workbook

From: Bob Phillips (bob.phillips_at_notheretiscali.co.uk)
Date: 03/07/05 

Date: Mon, 7 Mar 2005 16:42:31 -0000

VBA?

Sub NamesList()
Dim sh As Work***
Dim nme As Name
Dim i As Long

    On Error Resume Next
    Set sh = Worksheets("Names List")
    If sh Is Nothing Then
        Worksheets.Add.Name = "Names List"
    End If
    On Error GoTo 0
    With Worksheets("Names List")
        For Each nme In ActiveWorkbook.Names
            i = i + 1
            .Cells(i, "A").Value = nme.Name
            .Cells(i, "B").Value = nme.RefersTo
        Next nme
    End With
End Sub 

-- 
HTH
RP
(remove nothere from the email address if mailing direct)
"NameSearcher" <NameSearcher@discussions.microsoft.com> wrote in message
news:7C882FBE-9FCC-43FC-9B66-2E10F19FA422@microsoft.com...
> 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.
> >
> >