Names

Location: http://www.mvps.org/dmcritchie/excel/names.htm      
Home page: http://www.mvps.org/dmcritchie/excel/excel.htm
[View without Frames]

Descripton of Names

See help articles

Entry of a Name

The quickest way to enter a name is in the name box at the far left of the formula bar.

Restrictions on Names

Let's get what you can and can't do with names in the name box clear, Posting by Norman Harker, 2003-01-27, misc. Syntax of a name: A name is applicable for the entire workbook, unless explicitly given a sheetname. [..find a specific reference and usage...]

Macros involving named ranges (#names)

Macro to Show Names
Sub ShowAlllNames()
'Bob Umlas, excel.misc,  2007-05-03
Dim nName As Name
    For Each nName In Names
            nName.Visible=true
    Next nName
End Sub
Macro to Delete all names in a workbook
 Sub DeleteallNames()
 'Mike, excel.misc, 2007-03-14
 Dim nName As Name
     For Each nName In Names
             nName.Delete
     Next nName
 End Sub

Related


This page was introduced on January 17, 2003. 

[My Excel Pages -- home]    [INDEX to my site and the off-site pages I reference] 
[Site Search -- Excel]     [Go Back]    [Return to TOP

Please send your comments concerning this web page to: David McRitchie send email comments


Copyright © 1997 - 2004,  F. David McRitchie,  All Rights Reserved