Results 1 to 7 of 7
  1. #1
    2 Star Lounger
    Join Date
    Mar 2003
    Location
    London, Gtr London
    Posts
    131
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Creating a list from worksheet names (2003)

    Hi

    How can I convert a list of worksheet names into a list format in a column?

    I have attached a screen print of what I'm trying to achieve.

    Cheers
    Hayden

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Creating a list from worksheet names (2003)

    Something like this

    <pre>Sub GetSheets()
    Dim j As Integer
    For j = 1 To Sheets.Count
    Cells(j, 1) = Sheets(j).Name
    Next j
    End Sub</pre>


    This gets all sheets not just worksheets. If you want just the worksheets change the 2 "Sheets" to "Worksheets"

    Steve

  3. #3
    2 Star Lounger
    Join Date
    Mar 2003
    Location
    London, Gtr London
    Posts
    131
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Creating a list from worksheet names (2003)

    Steve, this is exactly what I needed, thats very much!

    Hayden

  4. #4
    Silver Lounger
    Join Date
    Dec 2000
    Location
    Northampton, Northamptonshire, England
    Posts
    1,951
    Thanks
    2
    Thanked 1 Time in 1 Post

    Re: Creating a list from worksheet names (2003)

    Hi

    You might want to download this free programme from www.asap-utilities.com, it will do what you require and lots more.

    Braddy

    NB I'm sorry you will have to type in the address as I am not sure how to create a hyperlink in the lounge.
    If you are a fool at forty, you will always be a fool

  5. #5
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Creating a list from worksheet names (2003)

    <hr>I'm sorry you will have to type in the address as I am not sure how to create a hyperlink in the lounge.<hr>
    See help on the url markup

    Steve

  6. #6
    Silver Lounger
    Join Date
    Dec 2000
    Location
    Northampton, Northamptonshire, England
    Posts
    1,951
    Thanks
    2
    Thanked 1 Time in 1 Post

    Re: Creating a list from worksheet names (2003)

    Hi Steve

    You say I-click TagPanels are also provided just above the text area, I think I must be going senile because I can't see them!!

    Braddy
    If you are a fool at forty, you will always be a fool

  7. #7
    Silver Lounger
    Join Date
    Dec 2000
    Location
    Northampton, Northamptonshire, England
    Posts
    1,951
    Thanks
    2
    Thanked 1 Time in 1 Post

    Re: Creating a list from worksheet names (2003)

    Sorry Steve

    I couldn't see them because I wasn't making a new post "Doh"

    Braddy
    If you are a fool at forty, you will always be a fool

Posting Permissions

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