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;
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
edited Mar 9 '15 at 16:05
Mathieu Guindon
44.8k770157
asked Mar 9 '15 at 15:44
Václav KyselýVáclav Kyselý
62
add a comment |
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
edited Mar 9 '15 at 16:05
Mathieu Guindon
44.8k770157
asked Mar 9 '15 at 15:44
Václav KyselýVáclav Kyselý
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
add a comment |
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
edited Mar 9 '15 at 16:05
Mathieu Guindon
44.8k770157
asked Mar 9 '15 at 15:44
Václav KyselýVáclav Kyselý
62
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
vba
edited Mar 9 '15 at 16:05
Mathieu Guindon
44.8k770157
asked Mar 9 '15 at 15:44
Václav KyselýVáclav Kyselý
62
edited Mar 9 '15 at 16:05
Mathieu Guindon
44.8k770157
asked Mar 9 '15 at 15:44
Václav KyselýVáclav Kyselý
62
edited Mar 9 '15 at 16:05
Mathieu Guindon
44.8k770157
edited Mar 9 '15 at 16:05
Mathieu Guindon
44.8k770157
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
asked Mar 9 '15 at 15:44
Václav KyselýVáclav Kyselý
62
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
add a comment |
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
add a comment |
2 Answers
2
active
oldest
votes
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
answered Mar 9 '15 at 16:05
OpiesDadOpiesDad
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
add a comment |
I solved by filling the values directly into the field into the FOR loop
Example. ArrayTemp(x) = SheetPrintPDFTemp
edited Jul 8 '15 at 4:50
0m3r
8,10192555
answered Mar 11 '15 at 12:41
Václav KyselýVáclav Kyselý
62
add a comment |
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
);
);
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
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
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
answered Mar 9 '15 at 16:05
OpiesDadOpiesDad
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
add a comment |
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
answered Mar 9 '15 at 16:05
OpiesDadOpiesDad
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
add a comment |
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
answered Mar 9 '15 at 16:05
OpiesDadOpiesDad
2,8901925
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
answered Mar 9 '15 at 16:05
OpiesDadOpiesDad
2,8901925
answered Mar 9 '15 at 16:05
OpiesDadOpiesDad
2,8901925
answered Mar 9 '15 at 16:05
OpiesDadOpiesDad
2,8901925
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
add a comment |
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
add a comment |
I solved by filling the values directly into the field into the FOR loop
Example. ArrayTemp(x) = SheetPrintPDFTemp
edited Jul 8 '15 at 4:50
0m3r
8,10192555
answered Mar 11 '15 at 12:41
Václav KyselýVáclav Kyselý
62
add a comment |
I solved by filling the values directly into the field into the FOR loop
Example. ArrayTemp(x) = SheetPrintPDFTemp
edited Jul 8 '15 at 4:50
0m3r
8,10192555
answered Mar 11 '15 at 12:41
Václav KyselýVáclav Kyselý
62
add a comment |
I solved by filling the values directly into the field into the FOR loop
Example. ArrayTemp(x) = SheetPrintPDFTemp
edited Jul 8 '15 at 4:50
0m3r
8,10192555
answered Mar 11 '15 at 12:41
Václav KyselýVáclav Kyselý
62
I solved by filling the values directly into the field into the FOR loop
Example. ArrayTemp(x) = SheetPrintPDFTemp
edited Jul 8 '15 at 4:50
0m3r
8,10192555
answered Mar 11 '15 at 12:41
Václav KyselýVáclav Kyselý
62
edited Jul 8 '15 at 4:50
0m3r
8,10192555
edited Jul 8 '15 at 4:50
0m3r
8,10192555
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
answered Mar 11 '15 at 12:41
Václav KyselýVáclav Kyselý
62
answered Mar 11 '15 at 12:41
Václav KyselýVáclav Kyselý
62
62
add a comment |
add a comment |
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.
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
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
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
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
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