×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

VBA Visual Basic for Applications (Microsoft) FAQ

Names Collection

How to get all the names in a workbook by MissyEd
Posted: 23 Nov 00

This sub will enumerate the names in a workbook.  You can pass the current workbook to it e.g
colored text Call sGetWorkBookNames(ActiveWorkbook)

Private Sub sGetWorkBookNames(myworkBook As Workbook)
    Dim iCount As Integer, myNames As Names

    Set myNames = myworkBook.Names
      
    For iCount = 1 To myNames.Count
        Debug.Print myNames(iCount).Name
    Next iCount
    
    Set myNames = Nothing
End Sub

Back to VBA Visual Basic for Applications (Microsoft) FAQ Index
Back to VBA Visual Basic for Applications (Microsoft) Forum

My Archive

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close