+ Reply to Thread
Results 1 to 5 of 5

Select multiple sheets(array) if sheet names are from cell value or string

  1. #1
    Registered User
    Join Date
    02-11-2018
    Location
    midlands
    MS-Off Ver
    2016
    Posts
    1

    Select multiple sheets(array) if sheet names are from cell value or string

    I am trying to select multiple/two sheets like: Sheets(Array("AAA", "BBB").Select
    There will be different number of sheets in workbook with different names each time the macro is run.

    I have function which creates names in string with all the formatting: "AAA", "BBB" and shows it in cell A1 or it could by all typed into the cell.

    Is there any way for below to work?

    "AAA", "BBB" typed into A1

    Sub

    Dim CCC As .....
    CCC = Range("a1").Value

    Sheets(Array(CCC).Select or Sheets(CCC).Select
    End

    It works fine with one sheet - eg "Sheet1" or "AAA" but it does not like the format with multiple sheets "Sheet1", "Sheet2" .
    What do I need to do with CCC = Range("a1").Value .
    Last edited by marvay; 02-11-2018 at 08:09 PM.

  2. #2
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: Select multiple sheets(array) if sheet names are from cell value or string

    Could be either:

    Please Login or Register  to view this content.
    I think
    If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)

    You can't do one thing. XLAdept

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin

  3. #3
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,523

    Re: Select multiple sheets(array) if sheet names are from cell value or string

    Quote Originally Posted by marvay View Post
    "AAA", "BBB" typed into A1
    Perhaps
    Please Login or Register  to view this content.

  4. #4
    Forum Contributor
    Join Date
    01-03-2018
    Location
    Fukuoka, Japan
    MS-Off Ver
    Excel 2013
    Posts
    123

    Re: Select multiple sheets(array) if sheet names are from cell value or string

    I vote for jindon's solution.

  5. #5
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: Select multiple sheets(array) if sheet names are from cell value or string

    @ yujin - always a solid bet

+ 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] Copy Paste From Rawdata Sheets to Multiple Sheets Based on Sheet names
    By farrukh in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-16-2017, 11:01 PM
  2. Select Sheets based on named range list of sheet names
    By cchen212 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-07-2017, 06:12 PM
  3. Sum Salaries from separate sheets - Sheet names in a dynamic array
    By perducci in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 06-01-2016, 10:24 PM
  4. Select multiple sheets that are stored in an array (VBA)
    By jkj115 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-26-2015, 06:56 PM
  5. [SOLVED] Create Sheets and copy rows to the Sheets if cell contains sheet names
    By CRIMEDOG in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-08-2015, 08:06 AM
  6. [SOLVED] Multiple Sheets to 1 PDF (Select Sheet If Cell ="N")
    By dmarzean in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 02-15-2014, 02:56 PM
  7. Search for Multiple String Values on Multiple Sheets and Copy Rows to New Sheet
    By rrtikker in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-15-2012, 12:21 PM

Tags for this Thread

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