+ Reply to Thread
Results 1 to 4 of 4

Macro to create a list of sheets, separated with comma in a single cell

  1. #1
    Registered User
    Join Date
    08-02-2012
    Location
    london
    MS-Off Ver
    Excel 2010
    Posts
    1

    Macro to create a list of sheets, separated with comma in a single cell

    Hi all,

    I respectfully request your help with the following.

    I have a workbook with multiple tabs/sheets. Amongst them, I have a START and an END tab. I need a macro that would read Tab names between Start and End and list them in a SINGLE cell, separated by comma.
    I am going at it the long way - listing tabs, selecting the range between START and END and concatenating with a comma (which is where I get stuck anyway...).

    I am thinking there must be an easier way to do this...

    I appreciate you inputs! Thanks

  2. #2
    Forum Expert Tinbendr's Avatar
    Join Date
    06-26-2012
    Location
    USA
    MS-Off Ver
    Office 2010
    Posts
    2,125

    Re: Macro to create a list of sheets, separated with comma in a single cell

    Welcome to the board!

    there must be an easier way to do this...
    No. Not really.


    Please Login or Register  to view this content.
    David
    (*) Reputation points appreciated.

  3. #3
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: Office 365 in Windows environment
    Posts
    8,613

    Re: Macro to create a list of sheets, separated with comma in a single cell

    Try this:
    Please Login or Register  to view this content.
    PS. David: your macro will list all sheets different than START and END not just these between this two.
    Last edited by Kaper; 04-30-2014 at 10:24 AM.
    Best Regards,

    Kaper

  4. #4
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: Macro to create a list of sheets, separated with comma in a single cell

    Another:

    Please Login or Register  to view this content.
    Places results in a Sheet called SheetNames Range("A1")

    This version is non inclusive

    Please Login or Register  to view this content.
    Last edited by JOHN H. DAVIS; 04-30-2014 at 11:16 AM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Compare comma separated values in a cell to a list
    By SMB in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 10-03-2019, 01:10 AM
  2. [SOLVED] Facing problem in a Macro which compares 2 columns having comma separated / single values
    By Manish_Gupta in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-18-2014, 11:18 PM
  3. Replies: 3
    Last Post: 12-23-2013, 12:32 PM
  4. [SOLVED] Single cell Comma Separated Values to validation list [DIFFICULT QUESTION]
    By jgema in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 05-31-2013, 08:48 PM
  5. Column/cells to single cell comma separated data?
    By egeorge4 in forum Excel General
    Replies: 1
    Last Post: 04-27-2007, 03:53 PM

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1