Loading
Ozgrid Excel Help & Best Practices Forums

Excel Video Tutorials / Excel Dashboards Reports



Results 1 to 3 of 3

Thread: List All Worksheet Names

  1. #1
    Join Date
    14th July 2006
    Posts
    11

    List All Worksheet Names

    Hi all,

    Is there a way in VBA to get a list of all worksheet names in a workbook?

    Thanks,
    Jason

    Excel Video Tutorials / Excel Dashboards Reports


  2. #2
    Join Date
    18th November 2004
    Location
    God's Own Country
    Posts
    4,299

    Re: List Of All Worksheet Names In Vba?

    Hi,

    VB:
    Sub SheetNames() 
        Columns(1).Insert 
        For i = 1 To Sheets.Count 
            Cells(i, 1) = Sheets(i).Name 
        Next i 
    End Sub 
    
    

  3. #3
    Join Date
    14th July 2006
    Posts
    11

    Re: List Of All Worksheet Names In Vba?

    Thank you!!!

    Excel Video Tutorials / Excel Dashboards Reports


Thread Information

Users Browsing this Thread

There are currently 5 users browsing this thread. (0 members and 5 guests)

Possible Answers

  1. List All Worksheet Names Of Workbook
    By kherbert in forum EXCEL HELP
    Replies: 4
    Last Post: March 23rd, 2013, 00:20
  2. Replies: 1
    Last Post: May 12th, 2008, 10:39
  3. Renaming Worksheet Names From Data In Worksheet
    By Wrecking_Crew in forum EXCEL HELP
    Replies: 18
    Last Post: March 30th, 2007, 20:09
  4. Macro: List Worksheet Names & Count Of Data
    By Silver Fox in forum EXCEL HELP
    Replies: 3
    Last Post: October 27th, 2006, 02:59
  5. Replies: 2
    Last Post: June 6th, 2006, 07:34

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
porno