Results 1 to 5 of 5

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

Threaded View

  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.

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