Excel VBA Select multiple sheetHow 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?
Is it okay / does it make sense for another player to join a running game of Munchkin?
How do I rename a LINUX host without needing to reboot for the rename to take effect?
Hide Select Output from T-SQL
How to be diplomatic in refusing to write code that breaches the privacy of our users
Lay out the Carpet
Should my PhD thesis be submitted under my legal name?
voltage of sounds of mp3files
Teaching indefinite integrals that require special-casing
What would happen if the UK refused to take part in EU Parliamentary elections?
Efficiently merge handle parallel feature branches in SFDX
Will it be accepted, if there is no ''Main Character" stereotype?
How does it work when somebody invests in my business?
Applicability of Single Responsibility Principle
Confused about a passage in Harry Potter y la piedra filosofal
Can I Retrieve Email Addresses from BCC?
What to do with wrong results in talks?
How do I keep an essay about "feeling flat" from feeling flat?
The plural of 'stomach"
Go Pregnant or Go Home
Curses work by shouting - How to avoid collateral damage?
Can somebody explain Brexit in a few child-proof sentences?
Can I use my Chinese passport to enter China after I acquired another citizenship?
How does residential electricity work?
What is the opposite of 'gravitas'?
Excel VBA Select multiple sheet
How 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?
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.3k769153
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.3k769153
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
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.3k769153
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.3k769153
asked Mar 9 '15 at 15:44
Václav KyselýVáclav Kyselý
62
edited Mar 9 '15 at 16:05
Mathieu Guindon
44.3k769153
asked Mar 9 '15 at 15:44
Václav KyselýVáclav Kyselý
62
edited Mar 9 '15 at 16:05
Mathieu Guindon
44.3k769153
edited Mar 9 '15 at 16:05
Mathieu Guindon
44.3k769153
edited Mar 9 '15 at 16:05
Mathieu Guindon
44.3k769153
44.3k769153
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
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
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
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,8701925
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,02292554
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,8701925
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,8701925
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,8701925
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,8701925
answered Mar 9 '15 at 16:05
OpiesDadOpiesDad
2,8701925
answered Mar 9 '15 at 16:05
OpiesDadOpiesDad
2,8701925
answered Mar 9 '15 at 16:05
OpiesDadOpiesDad
2,8701925
2,8701925
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,02292554
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,02292554
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,02292554
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,02292554
answered Mar 11 '15 at 12:41
Václav KyselýVáclav Kyselý
62
edited Jul 8 '15 at 4:50
0m3r
8,02292554
edited Jul 8 '15 at 4:50
0m3r
8,02292554
edited Jul 8 '15 at 4:50
0m3r
8,02292554
8,02292554
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
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