Excel VBA Select multiple sheet The 2019 Stack Overflow Developer Survey Results Are InHow can I select a number of sheets based of a list of the sheet namesHow to avoid using Select in Excel VBAMirroring column in one excel sheet to other multiple excel sheets with automatic updatingExcel VBA 2010 - Command buttons stop working with multiple sheets selectedExcel VBA: Changes to all sheets on same cellExcel Macro to hide rows across multiple sheetsMacro used on multiple workbooks to reset sheetsExcel VBA script to populate another sheet conditionallyHow to select the sheet with strings in excel vbaAddComment on multiple sheets vba Excelexcel vba Can With Worksheets(“Sheet1”) in main and in function effect the acual sheet?

Deal with toxic manager when you can't quit

What does ひと匙 mean in this manga and has it been used colloquially?

Why do some words that are not inflected have an umlaut?

Is there any way to tell whether the shot is going to hit you or not?

Can someone be penalized for an "unlawful" act if no penalty is specified?

Why hard-Brexiteers don't insist on a hard border to prevent illegal immigration after Brexit?

How come people say “Would of”?

How to manage monthly salary

One word riddle: Vowel in the middle

Worn-tile Scrabble

Is three citations per paragraph excessive for undergraduate research paper?

Time travel alters history but people keep saying nothing's changed

Right tool to dig six foot holes?

Am I thawing this London Broil safely?

What do hard-Brexiteers want with respect to the Irish border?

Identify boardgame from Big movie

What is the closest word meaning "respect for time / mindful"

How are circuits which use complex ICs normally simulated?

Do these rules for Critical Successes and Critical Failures seem Fair?

Should I use my personal e-mail address, or my workplace one, when registering to external websites for work purposes?

What does Linus Torvalds mean when he says that Git "never ever" tracks a file?

What is the most effective way of iterating a std::vector and why?

Can we generate random numbers using irrational numbers like π and e?

Is there a symbol for a right arrow with a square in the middle?



Excel VBA Select multiple sheet



The 2019 Stack Overflow Developer Survey Results Are InHow can I select a number of sheets based of a list of the sheet namesHow to avoid using Select in Excel VBAMirroring column in one excel sheet to other multiple excel sheets with automatic updatingExcel VBA 2010 - Command buttons stop working with multiple sheets selectedExcel VBA: Changes to all sheets on same cellExcel Macro to hide rows across multiple sheetsMacro used on multiple workbooks to reset sheetsExcel VBA script to populate another sheet conditionallyHow to select the sheet with strings in excel vbaAddComment on multiple sheets vba Excelexcel vba Can With Worksheets(“Sheet1”) in main and in function effect the acual sheet?



.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty height:90px;width:728px;box-sizing:border-box;








1















I'm trying to make a selection of multiple sheets one workbook based on run macros. At the end I have string containing sheets for selection, but my program prompt errors ...



Example:



SheetPrintPDF=Split(SheetPrintPDFTemp, ",") 
Rem Debug show me that SheetPrintPDFTemp contains "Sheet1, Sheet17, Sheet24"

Wb1.Sheets(Array(SheetPrintPDF)).Select
Rem Program error "method class sheet error"


when I write ...



Wb1.Sheets(Array("Sheet1", "Sheet17", "Sheet24")).Select 


Select works fine.










share|improve this question



















  • 1





    Could the whitespace after the comma be causing it? Try splitting on ", "

    – Mathieu Guindon
    Mar 9 '15 at 16:05






  • 1





    Just a side note: Rubberduck code inspections would flag "Use of obsolete Rem keyword" and suggest to replace it with an apostrophe ;)

    – Mathieu Guindon
    Mar 9 '15 at 16:51

















1















I'm trying to make a selection of multiple sheets one workbook based on run macros. At the end I have string containing sheets for selection, but my program prompt errors ...



Example:



SheetPrintPDF=Split(SheetPrintPDFTemp, ",") 
Rem Debug show me that SheetPrintPDFTemp contains "Sheet1, Sheet17, Sheet24"

Wb1.Sheets(Array(SheetPrintPDF)).Select
Rem Program error "method class sheet error"


when I write ...



Wb1.Sheets(Array("Sheet1", "Sheet17", "Sheet24")).Select 


Select works fine.










share|improve this question



















  • 1





    Could the whitespace after the comma be causing it? Try splitting on ", "

    – Mathieu Guindon
    Mar 9 '15 at 16:05






  • 1





    Just a side note: Rubberduck code inspections would flag "Use of obsolete Rem keyword" and suggest to replace it with an apostrophe ;)

    – Mathieu Guindon
    Mar 9 '15 at 16:51













1












1








1








I'm trying to make a selection of multiple sheets one workbook based on run macros. At the end I have string containing sheets for selection, but my program prompt errors ...



Example:



SheetPrintPDF=Split(SheetPrintPDFTemp, ",") 
Rem Debug show me that SheetPrintPDFTemp contains "Sheet1, Sheet17, Sheet24"

Wb1.Sheets(Array(SheetPrintPDF)).Select
Rem Program error "method class sheet error"


when I write ...



Wb1.Sheets(Array("Sheet1", "Sheet17", "Sheet24")).Select 


Select works fine.










share|improve this question
















I'm trying to make a selection of multiple sheets one workbook based on run macros. At the end I have string containing sheets for selection, but my program prompt errors ...



Example:



SheetPrintPDF=Split(SheetPrintPDFTemp, ",") 
Rem Debug show me that SheetPrintPDFTemp contains "Sheet1, Sheet17, Sheet24"

Wb1.Sheets(Array(SheetPrintPDF)).Select
Rem Program error "method class sheet error"


when I write ...



Wb1.Sheets(Array("Sheet1", "Sheet17", "Sheet24")).Select 


Select works fine.







vba






share|improve this question















share|improve this question













share|improve this question




share|improve this question








edited Mar 9 '15 at 16:05









Mathieu Guindon

44.8k770157




44.8k770157










asked Mar 9 '15 at 15:44









Václav KyselýVáclav Kyselý

62




62







  • 1





    Could the whitespace after the comma be causing it? Try splitting on ", "

    – Mathieu Guindon
    Mar 9 '15 at 16:05






  • 1





    Just a side note: Rubberduck code inspections would flag "Use of obsolete Rem keyword" and suggest to replace it with an apostrophe ;)

    – Mathieu Guindon
    Mar 9 '15 at 16:51












  • 1





    Could the whitespace after the comma be causing it? Try splitting on ", "

    – Mathieu Guindon
    Mar 9 '15 at 16:05






  • 1





    Just a side note: Rubberduck code inspections would flag "Use of obsolete Rem keyword" and suggest to replace it with an apostrophe ;)

    – Mathieu Guindon
    Mar 9 '15 at 16:51







1




1





Could the whitespace after the comma be causing it? Try splitting on ", "

– Mathieu Guindon
Mar 9 '15 at 16:05





Could the whitespace after the comma be causing it? Try splitting on ", "

– Mathieu Guindon
Mar 9 '15 at 16:05




1




1





Just a side note: Rubberduck code inspections would flag "Use of obsolete Rem keyword" and suggest to replace it with an apostrophe ;)

– Mathieu Guindon
Mar 9 '15 at 16:51





Just a side note: Rubberduck code inspections would flag "Use of obsolete Rem keyword" and suggest to replace it with an apostrophe ;)

– Mathieu Guindon
Mar 9 '15 at 16:51












2 Answers
2






active

oldest

votes


















1














The problem is that you don't need to label the array as an array in your desired code because it already is one. Try:



Wb1.Sheets(SheetPrintPDF).Select 





share|improve this answer























  • This and Mat's Mug's comment together fixed it

    – Alex
    Mar 9 '15 at 16:16











  • Hi result is "Runtime error 9 : Subscript is out of range"

    – Václav Kyselý
    Mar 10 '15 at 13:20


















0














I solved by filling the values directly into the field into the FOR loop



Example. ArrayTemp(x) = SheetPrintPDFTemp






share|improve this answer

























    Your Answer






    StackExchange.ifUsing("editor", function ()
    StackExchange.using("externalEditor", function ()
    StackExchange.using("snippets", function ()
    StackExchange.snippets.init();
    );
    );
    , "code-snippets");

    StackExchange.ready(function()
    var channelOptions =
    tags: "".split(" "),
    id: "1"
    ;
    initTagRenderer("".split(" "), "".split(" "), channelOptions);

    StackExchange.using("externalEditor", function()
    // Have to fire editor after snippets, if snippets enabled
    if (StackExchange.settings.snippets.snippetsEnabled)
    StackExchange.using("snippets", function()
    createEditor();
    );

    else
    createEditor();

    );

    function createEditor()
    StackExchange.prepareEditor(
    heartbeatType: 'answer',
    autoActivateHeartbeat: false,
    convertImagesToLinks: true,
    noModals: true,
    showLowRepImageUploadWarning: true,
    reputationToPostImages: 10,
    bindNavPrevention: true,
    postfix: "",
    imageUploader:
    brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
    contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
    allowUrls: true
    ,
    onDemand: true,
    discardSelector: ".discard-answer"
    ,immediatelyShowMarkdownHelp:true
    );



    );













    draft saved

    draft discarded


















    StackExchange.ready(
    function ()
    StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f28946120%2fexcel-vba-select-multiple-sheet%23new-answer', 'question_page');

    );

    Post as a guest















    Required, but never shown

























    2 Answers
    2






    active

    oldest

    votes








    2 Answers
    2






    active

    oldest

    votes









    active

    oldest

    votes






    active

    oldest

    votes









    1














    The problem is that you don't need to label the array as an array in your desired code because it already is one. Try:



    Wb1.Sheets(SheetPrintPDF).Select 





    share|improve this answer























    • This and Mat's Mug's comment together fixed it

      – Alex
      Mar 9 '15 at 16:16











    • Hi result is "Runtime error 9 : Subscript is out of range"

      – Václav Kyselý
      Mar 10 '15 at 13:20















    1














    The problem is that you don't need to label the array as an array in your desired code because it already is one. Try:



    Wb1.Sheets(SheetPrintPDF).Select 





    share|improve this answer























    • This and Mat's Mug's comment together fixed it

      – Alex
      Mar 9 '15 at 16:16











    • Hi result is "Runtime error 9 : Subscript is out of range"

      – Václav Kyselý
      Mar 10 '15 at 13:20













    1












    1








    1







    The problem is that you don't need to label the array as an array in your desired code because it already is one. Try:



    Wb1.Sheets(SheetPrintPDF).Select 





    share|improve this answer













    The problem is that you don't need to label the array as an array in your desired code because it already is one. Try:



    Wb1.Sheets(SheetPrintPDF).Select 






    share|improve this answer












    share|improve this answer



    share|improve this answer










    answered Mar 9 '15 at 16:05









    OpiesDadOpiesDad

    2,8901925




    2,8901925












    • This and Mat's Mug's comment together fixed it

      – Alex
      Mar 9 '15 at 16:16











    • Hi result is "Runtime error 9 : Subscript is out of range"

      – Václav Kyselý
      Mar 10 '15 at 13:20

















    • This and Mat's Mug's comment together fixed it

      – Alex
      Mar 9 '15 at 16:16











    • Hi result is "Runtime error 9 : Subscript is out of range"

      – Václav Kyselý
      Mar 10 '15 at 13:20
















    This and Mat's Mug's comment together fixed it

    – Alex
    Mar 9 '15 at 16:16





    This and Mat's Mug's comment together fixed it

    – Alex
    Mar 9 '15 at 16:16













    Hi result is "Runtime error 9 : Subscript is out of range"

    – Václav Kyselý
    Mar 10 '15 at 13:20





    Hi result is "Runtime error 9 : Subscript is out of range"

    – Václav Kyselý
    Mar 10 '15 at 13:20













    0














    I solved by filling the values directly into the field into the FOR loop



    Example. ArrayTemp(x) = SheetPrintPDFTemp






    share|improve this answer





























      0














      I solved by filling the values directly into the field into the FOR loop



      Example. ArrayTemp(x) = SheetPrintPDFTemp






      share|improve this answer



























        0












        0








        0







        I solved by filling the values directly into the field into the FOR loop



        Example. ArrayTemp(x) = SheetPrintPDFTemp






        share|improve this answer















        I solved by filling the values directly into the field into the FOR loop



        Example. ArrayTemp(x) = SheetPrintPDFTemp







        share|improve this answer














        share|improve this answer



        share|improve this answer








        edited Jul 8 '15 at 4:50









        0m3r

        8,10192555




        8,10192555










        answered Mar 11 '15 at 12:41









        Václav KyselýVáclav Kyselý

        62




        62



























            draft saved

            draft discarded
















































            Thanks for contributing an answer to Stack Overflow!


            • Please be sure to answer the question. Provide details and share your research!

            But avoid


            • Asking for help, clarification, or responding to other answers.

            • Making statements based on opinion; back them up with references or personal experience.

            To learn more, see our tips on writing great answers.




            draft saved


            draft discarded














            StackExchange.ready(
            function ()
            StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f28946120%2fexcel-vba-select-multiple-sheet%23new-answer', 'question_page');

            );

            Post as a guest















            Required, but never shown





















































            Required, but never shown














            Required, but never shown












            Required, but never shown







            Required, but never shown

































            Required, but never shown














            Required, but never shown












            Required, but never shown







            Required, but never shown







            Popular posts from this blog

            Save data to MySQL database using ExtJS and PHP [closed]2019 Community Moderator ElectionHow can I prevent SQL injection in PHP?Which MySQL data type to use for storing boolean valuesPHP: Delete an element from an arrayHow do I connect to a MySQL Database in Python?Should I use the datetime or timestamp data type in MySQL?How to get a list of MySQL user accountsHow Do You Parse and Process HTML/XML in PHP?Reference — What does this symbol mean in PHP?How does PHP 'foreach' actually work?Why shouldn't I use mysql_* functions in PHP?

            Compiling GNU Global with universal-ctags support Announcing the arrival of Valued Associate #679: Cesar Manara Planned maintenance scheduled April 23, 2019 at 23:30 UTC (7:30pm US/Eastern) Data science time! April 2019 and salary with experience The Ask Question Wizard is Live!Tags for Emacs: Relationship between etags, ebrowse, cscope, GNU Global and exuberant ctagsVim and Ctags tips and trickscscope or ctags why choose one over the other?scons and ctagsctags cannot open option file “.ctags”Adding tag scopes in universal-ctagsShould I use Universal-ctags?Universal ctags on WindowsHow do I install GNU Global with universal ctags support using Homebrew?Universal ctags with emacsHow to highlight ctags generated by Universal Ctags in Vim?

            Add ONERROR event to image from jsp tldHow to add an image to a JPanel?Saving image from PHP URLHTML img scalingCheck if an image is loaded (no errors) with jQueryHow to force an <img> to take up width, even if the image is not loadedHow do I populate hidden form field with a value set in Spring ControllerStyling Raw elements Generated from JSP tagds with Jquery MobileLimit resizing of images with explicitly set width and height attributeserror TLD use in a jsp fileJsp tld files cannot be resolved